4 ms·
>> if you're talking APIs here, you may not be doing too much much hand-authoring of queries No experience with GraphQL myself, but this is a very good point.
by TallGuyShort 7y ago
>> if you're talking APIs here, you may not be doing too much much hand-authoring of queries
No experience with GraphQL myself, but this is a very good point. A lot of the practical problems that come with SQL queries boil down to the code that constructs a string to be used as the query, so it can then be deconstructed by different code to execute the query. There's a lot of mistakes that happen right there.
- mumblemumble 7y agoAnd this is the pain I'm thinking of. Doing dynamically generated SQL that isn't susceptible to SQL injection can get tricky, and ORM frameworks generally only partially solve the problem for a certain subset of possible schemata. I do think SQL is a well-designed language. But it was designed, first and foremost, as a language for human analysts to bang into a terminal. Having computers flexibly communicate using it is an off-label use.