The Hasura platform’s data microservice provides an HTTP API to query Postgres using GraphQL or JSON in a permission safe way.
You can exploit foreign key constraints in Postgres to query hierarchical data in a single request. For example, you can run this query to fetch “albums” and all their “tracks” (provided the “track” table has a foreign key to the “album” table):
