Drizzle TeamDT
Drizzle Team•2y ago
Dush

Is custom mapping possible with Drizzle?

export const iziflow = pgSchema('iziflow')

export const vehicle = iziflow.table(
  'vehicle',
  {
   matriculation: varchar('matriculation')
  }
)


I'm trying to select from the mentioned table but instead of 
db.select({matriculation: vehicle.matriculation}).from(...)


I would like to get this result:
db.select({matriculation: {value: vehicle.matriculation}}).from(...)


but I get this TS error:
Object literal may only specify known properties, and 'value' does not exist in type 'SQL<unknown> | Aliased<unknown> | PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>'

is there a solution for that or should I do the mapping after the query?
Was this page helpful?