With the new prisma queryRaw, if I am doing a

where id IN (${Prisma.join(ids)})

where the id is a uuid, I get the error

Raw query failed. Code: `42883`. Message: `db error: ERROR: operator does not exist: uuid = text

what do I need to do to cast those correctly?

have you added

''

single quotes?

where id IN ('${Prisma.join(ids)}')

that wouldn't be right, the idea is that the resulting query would look like

where id IN ('uuid1', 'uuid2', 'uuid3')

where the above would do

where id IN ('uuid1,uuid2,uuid3')

Hi Tyler, can you have a look at this StackOverflow question: https://stackoverflow.com/questions/69195961/postgres-sql-error-42883-error-operator-does-not-exist-uuid-text It seems to discuss the same error that you are facing.