How to perform type casting in prisma?

[Josrph]

is it possible to cast a column from one type to another using prisma?

for example: cast an id column of type integer to a string then perform a contains query on the new string column.

[nurul3101]

Hello @Josrph 👋

Prisma queries will return data in the JavaScript types that correspond to the Prisma types defined in your schema.prisma. It’s possible to do SQL type casting, like casting from integer to string if you use $queryRaw.

[Josrph]

so the only option is to use $queryRaw.

[nurul3101]

At the moment, yes.