Hey, I'm trying to set up Supabase auth with Prisma. I've seen some threads in the channel for this, but none have any concrete replies. In addition I found a few threads on Prisma's repo with links on how this may be achieved, for example - https://github.com/prisma/prisma/issues/5128. I tried this out,

set

a custom variable

app.current_user_role

on a table which will allow Select only if

app.current_user_role

is

admin

But when I run this via Prisma, it returns all the rows, irrespective of this value. I wanted to know if this is a good idea at all, or if getting Prisma to work with Supabase auth is still tricky and best not attempted right now? Any pointers in the right direction would be great, thanks!