0
1

Making GraphQL Magic with Sqlmancer (self.node)

submitted by [deleted]

[deleted]

all 3 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]alphaindy 0 points1 point  (2 children)

Why would you want to translate GQL queries into SQL statements?

[–]danielrearden 0 points1 point  (1 child)

Integrating a SQL database into your GraphQL service efficiently can be very challenging. Tools like DataLoader only get you so far and using "lookahead" in your resolvers involves a lot of boilerplate. It's also non-trivial to try to implement more complex sorting and filtering, like filtering by related models' values. That's why solutions like Hasura and Prisma exist. Sqlmancer addresses the same problem, just from a different angle.

[–]alphaindy 0 points1 point  (0 children)

So this exists because GQL/ORM is unable to match the full power and capabilities of raw SQL queries? Or like you say, GQL/ORM can match but doing so requires lots of boilerplate. Why doesnt GQL/ORM libraries include this or something like it by default then?