Not the parent but we went with Hasura over postgraphile because they do RLS outside of the dB. It allows them to load the data for all clients subscribed in a single query. Also the subscription story is better (from memory).

With Hasura, you can create arbitrary roles (like admin, manager, etc) and restrict access to data on the basis of these roles.

These roles can be assigned to a frontend session by generating signed JWTs.

With Postgres RBAC, you'd need something to lift the roles to be consumed by the frontend. With Hasura it works out of the box.

Also, I did consider using Postgraphile, but it was easier to get started with Hasura, so I went ahead with it. I don't have enough info to make a comparison.