Wildcard with path in json extension

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Wildcard with path in json extension

Charles Leifer
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users