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

daniela florescu dflorescu at me.com
Mon Jun 1 14:44:28 PDT 2015

>> If you don't can't predict the schema your semi-structured is going to generate then  how could you write your query. 
> With difficulty. I can’t see anyone wanting to write it by hand.

Look at a simple path expression like 


(bread and butter for any semi-structured query language)

This would translate into the equivalent SQL with:
1. nested queries
2. nested RECURSIVE queries in fact
3. two outer joins.

Good luck with trying to:
1. write that by hand and
2. find a SQL implementation that optimizes and executes that properly….

And that’s “just” a simple $x//a//b…….

Now imagine your typical XQuery (soon to be JSOniq:-) program.

Best regards

More information about the talk mailing list