News for hackers. Stuff that matters.

A comment on How and why GraphQL will influence the Sourcehut alpha. Parent comment

Re:How and why GraphQL will influence the Sourcehut alpha by mixedCase on Friday June 12, 2020 @09:14AM (#23498872)
No such thing. The database interface is SQL. The query optimizer is something run in the database.
[ Parent | on HN ]
Re:How and why GraphQL will influence the Sourcehut alpha by goto11 on Friday June 12, 2020 @09:36AM (#23499077)
Yes I mean inside the database engine. The engine receives SQL and parses it and then pass the query tree to the optimizer which generate a query plan. My question is how the optimizer could have problems if the SQL is generated as opposed to hand-written? How could that make a difference?
[ Parent | on HN ]
Re:How and why GraphQL will influence the Sourcehut alpha by mixedCase on Friday June 12, 2020 @03:18PM (#23502636)
As mentioned in another the comment, because SQL that is hand-written for non-trivial cases will too often be better than what an ORM generates.
[ Parent | on HN ]
Re:How and why GraphQL will influence the Sourcehut alpha by goto11 on Saturday June 13, 2020 @01:33PM (#23511081)
This is so hand-wavy I can't really argue against it.
[ Parent | on HN ]