The response fails and when it succeeds it takes more than 5 seconds:
One possible solution will be to replace the Prisma query with a raw query, another is to create a Postgres view in Supabase.
I can open a PR with the preferred solution.
We improved this significantly in the next release. We're still doing some improvements and refinements. We should have it fixed and ready for the next release.
The response fails and when it succeeds it takes more than 5 seconds:
One possible solution will be to replace the Prisma query with a raw query, another is to create a Postgres view in Supabase. I can open a PR with the preferred solution.