[xquery-talk] the stupidity of using SQL as a query language for JSON

[Michael Kay]

> 
> Using SQL to process JSON is simply NOT POSSIBLE.
> 

Proof?

My Ph.D. thesis in 1975 showed that you can use SQL to query hierarchic data. With the emphasis on “query”. The problems start with update. So long as you restrict yourself to query, you can map almost any data model onto any other.

Though the fact that you can do it doesn’t mean that it’s a good idea, of course. In those days the reason for doing it was that SQL was the only declarative query language in town, and that’s no longer the case.

Michael Kay
Saxonica