Tenant isolation fails closed
A query that loses its tenant scope returns nothing, not everything.
Row-level security is enforced in Postgres, so isolation does not depend on an application remembering to filter. Entitlement checks are SECURITY DEFINER functions with the scope baked in, and the failure mode of a mistake is an empty result rather than another tenant's data.