Join query select only fields of one table

[Tirke]

Taking the example from the docs:

export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
});
 
export const pets = pgTable('pets', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  ownerId: integer('owner_id').notNull().references(() => users.id),
})

const result = await db.select().from(users).leftJoin(pets, eq(users.id, pets.ownerId))

Let's say I'm only interested in the fields of the users tables, I would do select users.* in SQL but I'm failing to find a way to do this kind of filtering in drizzle. That would save me an additional mapping of the result to only contain data I'm interested in.

[binajmen]

Hi @Tirke, did you manage to find an elegant solution?

[Tirke]

I still think there is not way for drizzle to issue such query so I'm still mapping using code (Array.map)

[binajmen]

Someone on Discord suggested this:
https://orm.drizzle.team/docs/goodies#get-typed-table-columns

It works pretty well:

db.select({ ...getTableColumns(accounts) }).from(accounts)

[Tirke]

Pretty cool thanks :)