Re:REPL: To JSON what Excel is to CSV
by _delirium on Wednesday February 19, 2014 @09:06AM
(#7263649)
It doesn't have very SQLish syntax, but there are various JSON ports of XPath and XQuery from the XML world.
Re:REPL: To JSON what Excel is to CSV
by cousin_it on Wednesday February 19, 2014 @09:37AM
(#7263773)
Ooh, that's exactly what I was looking for. Thanks!
Re:REPL: To JSON what Excel is to CSV
by schrodinger on Wednesday February 19, 2014 @09:26AM
(#7263720)
linq in .Net does a pretty good job with SQL-like queries against nested records. Also, many SQL implementations support querying against XML data stored within the database, which is effectively a nested record.
What I really want is SQL for JSON. Regular SQL is a declarative language for transforming flat lists of records into other flat lists of records, and the challenge is extending it to allow nested records. Has that been done?