Best way to omit a field (e.g. password) after findMany from schema?

Let's say we have the following:

export const User = pgTable(
  'user',
  {
    id: serial('id').primaryKey(),
    name: varchar('name', { length: 256 }),
    email: varchar('phone', { length: 256 }),
    password: text('password'),
    createdAt: timestamp('created_at', { withTimezone: true })
      .notNull()
      .defaultNow(),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .notNull()
      .defaultNow(),
  },
  (user) => {
    return { idIdx: index('id_idx').on(user.id) };
  },
);

export const UserRelation = relations(User, ({ many }) => ({
  shops: many(Shop),
  products: many(Product),
}));

export type NewUser = InferModel<typeof User, 'insert'>;

export type Users = InferModel<typeof User>;

export const User = pgTable(
  'user',
  {
    id: serial('id').primaryKey(),
    name: varchar('name', { length: 256 }),
    email: varchar('phone', { length: 256 }),
    password: text('password'),
    createdAt: timestamp('created_at', { withTimezone: true })
      .notNull()
      .defaultNow(),
    updatedAt: timestamp('updated_at', { withTimezone: true })
      .notNull()
      .defaultNow(),
  },
  (user) => {
    return { idIdx: index('id_idx').on(user.id) };
  },
);

export const UserRelation = relations(User, ({ many }) => ({
  shops: many(Shop),
  products: many(Product),
}));

export type NewUser = InferModel<typeof User, 'insert'>;

export type Users = InferModel<typeof User>;

How can we use drizzle-zod to omit the password in (for example) an API response after running a findMany query? The docs mention it can be used for this purpose, but it doesn't show how. Or am I just thinking about this the wrong way? If so, what is the right way?

Usage – DrizzleORM

Drizzle ORM | %s

1 Reply

predragnikolic•13mo ago

https://orm.drizzle.team/docs/rqb#nested-partial-fields-select

Drizzle Queries - DrizzleORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind

Gaming

Programming

Best way to omit a field (e.g. password) after findMany from schema?