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
$[? filter ] vs
Other JSON query languages
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 !