RLS sounds great until it isn't

PostgreSQL’s Row Level Security sounds like a clean way to enforce access control at the database layer, but the foot-guns, pooling incompatibilities, and performance traps often make it more trouble than it’s worth.