Many of the sqlite json1 functions accept a path parameter, which the documents describe as:
For functions that accept PATH arguments, that PATH must be well-formed or else the function will throw an error. A well-formed PATH is a text value that begins with exactly one '$' character followed by zero or more instances of ".objectlabel" or "[arrayindex]". I was wondering if there were any plans to support wildcard paths? Postgres v12 release looks like it has a pretty sophisticated jsonpath type. Examples: SELECT jsonb_path_query(x, '$.** ? (@.name == "a")') FROM test; SELECT jsonb_path_query(x, '$.sizes[1 to last]') FROM test; MySQL allows wildcards in a couple flavors. Do you anticipate anything like this landing in sqlite's json extension? Thank you for the wonderful software, Charles _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users