I am wondering if anyone can spot something i am doing wrong or if this is a Prisma issue / limitation. I am trying to run a simple query using

$queryRaw

(Prisma Client 3.13.0) with SQLite.

SELECT value FROM generate_series(5,100,5)

. (This is just an example from the SQLite docs). Unfortunately I am getting the error

no such table: generate_series

. Any input would be appreciated.

Hey Neil 👋 Are you getting the same error when trying out other raw query methods as well? E.g Can you try queryRawUnsafe? It seems you are running into this GitHub Issue: #9197

Hi @Nurul, thanks for the quick response. Yes I am also getting the same issue with running with

queryRawUnsafe

unfortunately. I did see the issue you mentioned when i searched before posting, however I was unsure if it was related as I am using SQLite (with no typecasting) and the Github issue seem to suggest the problem is surrounding typecasting.

Yes, the issue is related. We are shipping a new version of queryRaw later today, can you update your

@prisma/client

version once we publish the new release? we will post about the new release in #announcements

Yes I will do! Thank you!

You can check if you are using any preview features by running

npx prisma -v

Can you run it and see if you get improvedQueryRaw in output?

It is showing

improvedQueryRaw

in the output

Could you create a Bug Report here so that our engineering team could have a look?