Postgres RLS

Row Level Security

• RLS policies are applied transparently to all queries

• Difficult to track why a query doesn't return specific rows

• RLS policies are not explicitly visible in SQL logs

• Difficult to control when used with ORMs like Drizzle

• Migration management challenges

• Difficult to implement complex relationship-based permissions