DT
Drizzle Team•3y ago
McLean 25

Select wildcard

I'm sure someone's asked this before but I can't find it. Is there not a way to do a .select() wildcard so that I can do something like: 
db.select((defaultFields) => ({
  max: sql<string>`MAX(${file.createdAt})`
  ...defaultFields
})).from(table);
db.select((defaultFields) => ({
  max: sql<string>`MAX(${file.createdAt})`
  ...defaultFields
})).from(table);
3 Replies
McLean 25
McLean 25OP•3y ago
rphlmr ⚡
rphlmr ⚡•3y ago
I do things like this: 
import { getTableColumns, sql, eq } from "drizzle-orm";

export async function getUser(id: string) {
  return db
    .select({
      ...getTableColumns(User),
      fullName: sql<string>`${User.firstName} || ' ' || ${User.name}`,
    })
    .from(User)
    .where(eq(User.id, id))
    .then(takeFirstOrThrow);
}
import { getTableColumns, sql, eq } from "drizzle-orm";

export async function getUser(id: string) {
  return db
    .select({
      ...getTableColumns(User),
      fullName: sql<string>`${User.firstName} || ' ' || ${User.name}`,
    })
    .from(User)
    .where(eq(User.id, id))
    .then(takeFirstOrThrow);
}
getTableColumns will grab ... all table columns :p
McLean 25
McLean 25OP•3y ago
Nice, thanks!

Did you find this page helpful?