Re:PostgREST – Serve a RESTful API from Any Postgres Database
by smallnamespace on Thursday December 29, 2022 @12:31PM
(#34175207)
PostgreSQL row-level security (which PostgREST defers to) is very flexible, more or less anything expressible as a SQL query can be used to filter what the user can see.
You can see an example here: https://postgrest.org/en/stable/auth.html#roles-for-each-web...
The main downside of RLS is that complex queries may require hand-optimizing.