3 ms·
Yeah, I don't understand the comparison to Excel either. What I really want is SQL for JSON. Regular SQL is a declarative language for transforming flat lists
by cousin_it 13y ago
Yeah, I don't understand the comparison to Excel either.
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?
- _delirium 13y agoIt doesn't have very SQLish syntax, but there are various JSON ports of XPath and XQuery from the XML world.
- cousin_it 13y agoOoh, that's exactly what I was looking for. Thanks!
- schrodinger 13y agolinq 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.
- antfarm 13y agohttp://stedolan.github.io/jq/ http://stedolan.github.io/jq/