json query and json path

Question

I try not to make this a loaded question, but a quite focused one instead --

when talking about processing JSON data, I thought people have converged, from different fancy ways to query json structures, to just JSONPath, AKA JPath, "proposed by Stefan Goessner allows for XPath-like expressions to be evaluated against JSON".

At least I thought so, until I take a closer look today at the syntax of jq, which looks quite similar to JPath, but actually different, and more advanced.

So, my question is, any one knows where its syntax is coming from (as jq doesn't say so on its web site)?

Further, it doesn't say what jq stands for either. So let me assume it stands for "json query". So the next question is, of all json query tool listed in jsonquerytool.com, (i.e., JSONPath, JSPath, Lodash, Underscore, JPath, XPath for JSON, JSON Pointer and just plain old JavaScript),

whose syntax are closer to JPath, and whose are closer to jq, or their syntax are just "all-over-the-places", i.e., each are quite different from others.

charles ross · Accepted Answer · 2018-02-28 17:37:09Z

1

Your answer to this question is "all-over-the-places". There must be dozens of JSON Query languages proposed and implemented now. jq is very popular in Data Science. It also has an online sandbox at https://jqplay.org/

I was unaware of recent clampdown on SO questions so I asked a general Q about this topic and got shut down. No surveys, no off site refs allowed. JSON Query in 2018: most used languages?

Stack-O data science geeks ought to try a tally up and report of the JSON Query languages. Right now it's the wild kingdom.

2 others not on your list are JSONiq and XPath 3.1. Xpath (along with XQuery) is a W3 standard. JSON was created in part as a lean replacement for XML so I think they are nearly isomorphic so far as data structures.

answered Feb 28, 2018 at 17:37

charles ross

5825 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

json query and json path

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related