jsonpath
jsonpath copied to clipboard
SQL/JSONPath support
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
Also, it separates the path from the value filter.
$.store.book[?(@.price<10)]
becomes
$.store.book[*].price ? (@ < 10)