View to compose two fields?

Hello

I have three columns in my auth table today,

name

name

givenName

givenName

givenName

givenName, and

familyName

familyName

familyName

familyName. I was looking to get rid of the

name

name

one, and have a "view" that creates the

name

name

based on the other two.

I looked at the docs but I can't really figure it out: https://orm.drizzle.team/docs/views

Is it possible?

KirbyTwister•6/6/25, 4:07 PM

Pretty sure you can just define it as a computed column like:

db.select({
  givenName: Users.givenName,
  familyName: Users.familyName,
  name: sql<string>`${Users.givenName} || '' || ${Users.familyName}`.as('name')
})

db.select({
  givenName: Users.givenName,
  familyName: Users.familyName,
  name: sql<string>`${Users.givenName} || '' || ${Users.familyName}`.as('name')
})

View to compose two fields?

Similar Threads

Similar Threads

Similar Threads