support for JSON/SQL style filters?

[bdeboe]

JSON/SQL implementations such as PostgreSQL and Oracle seem to use a slightly different style of filters than what is supported by this library:

select * from jsonb_path_query('{"a":[1,2,3,4,5]}', '$.a[*] ? (@ >= 2 && @ <= 4)') -- Postgres

select * from JSON_QUERY('...', '$.friends[3]?(@.addresses.city == "San Francisco")') -- Oracle

Whereas those JSONPath expressions would have to be rewritten to $.a[? (@ >= 2 && @ <= 4)] and $.friends[3, ?(@.addresses.city == "San Francisco")], respectively to work for this library. Has this request come up before? Anyone knows a library that follows this approach?

Note that the latter example combines an index with a filter as requested in #50, for which the "SQL notation" might actually be a helpful approach.