JSON query languages

comparison.md

JSON query languages

• JSONPath is was created 2007, inspired by XPath. A formal standard is being created at https://github.com/ietf-wg-jsonpath/draft-ietf-jsonpath-base
• SQL/JSON path was created inspired by JSONPath and other query languages.
• jq is a programming language with strong support of JSON transformation
• JSON Pointer only references a single element

Most important conflicting difference between JSONPath and SQL/JSON path is $.["name"] vs $."name" and $[? filter ] vs $?(filter).

Other JSON query languages

• JAQL
• JMESPath
• JSONata
• JSONiq
• JSONPath

Minimal subset of JSONPath (JSON Basic Path)

• No filter expression
• No list selector
• No array slice
• No functions
• No Descendant Selector

json-basic-path = root-selector *(S (dot-selector        /
                               dot-wild-selector   /
                               index-selector      /
                               index-wild-selector ))

$
$.*
$.name
$."name" not allowed in JSONPath !