Hi I’m currently trying to upgrade to Prisma 4 and I’m having a little casting issues in some

$queryRaw()

Example query:

const rows = await this.prismaClient.$queryRaw<
  { id: string; location: string }[]
>(Prisma.sql`
  SELECT id, ST_AsGeoJSON(location) as location,
  FROM something
  WHERE id IN (${Prisma.join(ids)})
`);

I get some type errors I didn’t have in previous versions:

ERROR: operator does not exist: uuid = text

I’ve tried various way to cast my list of

ids

to uuids, but to no avail so far.

IN (${Prisma.join(ids)}::uuid[]) IN (${Prisma.join(ids)})::uuid[]

I wouldn’t mind some help there since I might be missing something simple 😅

Thank you for opening the GitHub Issue. 🙌 I can see a colleague has already triaged the issue, so they should get back to you on the GitHub Issue.

wouldn’t be first time I catch a little regression 😄