Hey, is it discouraged to map custom application roles to Postgres roles directly (e.g., creating an
admin
admin
and
user
user
Postgres role and assigning them via the JWT role claim)? Does doing so conflict with anything in the Supabase stack like RLS, Auth, or the dashboard? And if so, how do people typically handle role-based column-level permissions when different user types need to update different columns on the same table?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.