[hprotagonist]

i've been using simonw's sqlite-utils (https://sqlite-utils.datasette.io/en/stable/) for this sort of thing; given structured json or jsonl, you can throw data at an in-memory sqlite database and query away: https://sqlite-utils.datasette.io/en/stable/cli.html#queryin...

[mutant]

Thank you was going to say this as well, sqlite does this the same as duckdb