Is custom mapping possible with Drizzle?

export const iziflow = pgSchema('iziflow')

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

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(...)

db.select({matriculation: vehicle.matriculation}).from(...)

I would like to get this result:

db.select({matriculation: {value: vehicle.matriculation}}).from(...)

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>, {}, {}>'

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?

Drizzle Team•3y ago

Dush

Is custom mapping possible with Drizzle?

export const iziflow = pgSchema('iziflow')

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

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(...)

db.select({matriculation: vehicle.matriculation}).from(...)

I would like to get this result:

db.select({matriculation: {value: vehicle.matriculation}}).from(...)

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>, {}, {}>'

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?

Is custom mapping possible with Drizzle?

Similar Threads

Is custom mapping possible with Drizzle?

Similar Threads

Similar Threads

Similar Threads