The author says SQL is the language for manipulating relational data. And then proceeds to complain SQL sucks at manipulating JSON.
Hmm. JSON is not relational. SQL expects data to be in third normal form.
If you are primarily working with JSON, please use something else.
The other two criticisms about SQL verboseness and reluctance to employ functions and other memory manipulations is the author’s confusion of the intended purpose of SQL. SQL treats data as the first class citizen. Think of data as the noun. SQL DML and SQL functions are modifiers. This is why SQL appears verbose. It is dragging all these data structures around. If you want to reduce SQL’s verbosity then you need to take an axe to the raw tables themselves and make them all cookie cutter. But then you have a completely different problem.
rawgabbit•4mo ago
The author says SQL is the language for manipulating relational data. And then proceeds to complain SQL sucks at manipulating JSON.
Hmm. JSON is not relational. SQL expects data to be in third normal form.
If you are primarily working with JSON, please use something else.
The other two criticisms about SQL verboseness and reluctance to employ functions and other memory manipulations is the author’s confusion of the intended purpose of SQL. SQL treats data as the first class citizen. Think of data as the noun. SQL DML and SQL functions are modifiers. This is why SQL appears verbose. It is dragging all these data structures around. If you want to reduce SQL’s verbosity then you need to take an axe to the raw tables themselves and make them all cookie cutter. But then you have a completely different problem.