3 ms·
> We don't want to do meta programming where we have another language living as a string in our web app. Strings are fine in theory, but the trouble with SQL i
by 9rx 2y ago
> We don't want to do meta programming where we have another language living as a string in our web app.
Strings are fine in theory, but the trouble with SQL is that, while too high-level in all the wrong places, it is also too low-level in all the wrong places. Developers want to be able to do things like define the shape of the data beyond tables and compose queries, which SQL fails hard at. In order to accomplish what developers need, you either end up extending SQL into a new language, or you can use the programming constructs you already have, treating SQL as a compiler target, where necessary. The latter is considerably easier to implement.