I am using drizzle v1 beta with supabase. I've enabled RLS policies on some tables, and upon testing, I've discovered that the rules are not applied. That's because the postgres function auth.uid() simply has no access to any JWT claims, because I don't have an integration with supabase...

I've found some solutions for previous drizzle version 0.4x which is outdated.

https://github.com/stabildev/next-drizzle-supabase/blob/main/src/db/index.ts