Re:Things to know about databases
by tomnipotent on Wednesday June 29, 2022 @10:42AM
(#31920829)
Hasura, a GraphQL server, uses exactly this technique to transform final query results into JSON in PG before bringing back into local memory.
It just isn’t feasible to write everything out when the schema has >30 entities, some with N:M relations, and when queries routinely go several levels deep to fetch dozens of joined fields at every level. The boilerplate overhead is too much.
A natively GraphQL database makes such queries a magnitude less verbose to write out, and all the queries can stay in the frontend (or can become persisted queries on a GraphQL ”middle-end” server).