At least in Cosmos, there’s a good story with the indexing policy that’s very configurable. (Including fully automated if that’s what you need)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile

SQL Down Under | Web: https://sqldownunder.com | About Greg: https://about.me/greg.low

From: Greg Keogh via ozdotnet <ozdotnet@ozdotnet.com>
Sent: Friday, 2 September 2022 10:52 AM
To: ozDotNet <ozdotnet@ozdotnet.com>
Cc: Greg Keogh <gfkeogh@gmail.com>
Subject: Re: Indexed JSON documents (file system)

I found this: https://github.com/ketanip/dbjson hope it helps. 

If I had to do it myself I'd probably do something similar, maybe use SQLite to hold an index of the properties of JSON documents. I would have to walk every document's tree (fragile) and the hierarchy of properties would have to be represented as relational tables (hacky, not meant for that).

Still thinking -- Greg