[sqlite-dev] Json paths

[Charles Leifer]

Hi, I apologize first off if you've already read and dismissed the similar email I sent to the users mailing list. But on reflection, I thought maybe it would be more appropriate to send to this list.

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.