jsonpath icon indicating copy to clipboard operation
jsonpath copied to clipboard

SQL/JSONPath support

Open mattbishop opened this issue 4 years ago • 1 comments

SQL/JSONPath, part of SQL 2016, is a simplification of JSON Path that removes recursive descent (..), replaces negative array seeking with last and remakes array length to size(). An older writeup is here: https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016#json-path

mattbishop avatar Jul 27 '21 23:07 mattbishop

Also, it separates the path from the value filter.

$.store.book[?(@.price<10)]

becomes

$.store.book[*].price ? (@ < 10)

mattbishop avatar Jul 27 '21 23:07 mattbishop