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

[daniela florescu]

> 
> So pretty much no  subqueries (ok somebody is going to say that any query entailing a subquery can be rewritten without one) but AFAIC  the language you are talking about isn't really SQL then. 

That someone can come to me and I’ll show him/her gazzilions of nested queries that cannot be unnested (SQL and/or XQuery).

In fact, the ones you CAN unnest are pretty rare…..

(I think I listed ALL of unnestable cases of XQuery here if I remember correctly…there are not that many….
http://dl.acm.org/citation.cfm?id=1315537
)

Not even the simplest form:

for in for in … 

cannot always be unnested in most cases if I remember correctly ….

Best
Dana