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? There's some useful information on the MySQL JSON doc: https://dev.mysql.com/doc/refman/8.0/en/json.html#json-path-syntax Postgres seems to be doubling-down on json as well -- the v12 release looks like it has a dedicated jsonpath type: https://www.postgresql.org/docs/devel/datatype-json.html#DATATYPE-JSONPATH What do you think? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users