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:

Postgres seems to be doubling-down on json as well -- the v12 release looks
like it has a dedicated jsonpath type:

What do you think?
sqlite-users mailing list
[hidden email]