Is there a (roughly) SQL or XQuery-like language for querying JSON? I’m thinking of very small datasets that map nicely to JSON where it would be nice to easily...
Why doesn’t the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, because I would have thought this would return the...