hey everyone, a quick question about substring matching... imagine i have a user shaped like so,

model User {
  id                             String                     @id @default(uuid())
  givenName                      String
  familyName                     String
}

if i want to perform a LIKE query against that table, it is quite simple to search for either the given name or the family name, but it is unclear to me how to use Prisma to search for a full name across both columns. in PostgreSQL i could do the following,

WHERE (User.givenName || ' ' || User.familyName) LIKE ...

is something like this possible with prisma?

@Matt Langer 👋 Unfortunately not, but we do have a feature request here that you can add a 👍 and follow: https://github.com/prisma/prisma/issues/7181 As a workaround you need to use

prisma.$queryRaw

.