The fastest tool for querying large JSON files is written in Python (benchmark)
Allow me a moment to hijack this thread. I'm a PhD student looking to make analytics of JSON data a first-class citizen in <a href="https://duckdb.org/" rel="nofollow">https://duckdb.org/</a>. I'm still very much in a literature study stage, so I'd love to hear <i>your</i> success (or failure) stories about analyzing data stored in JSON. E.g. I'd love to hear about:<p>* Which dialect for querying worked the best for you?<p>* Which tools do you enjoy the most? This could be for any reason: convenience of install/availability, expressivity, raw speed, other niche features, etc.<p>* What sort of JSON "meta-formats" are the most important/common for you? E.g. in a file you could have object-per-line, object-of-arrays, array-of-objects, or in an SQL context you could have object-per-row or object-of-arrays-as-table, etc). I'd love to hear about others that are important to you.<p>* What do you feel is the biggest gap/missing feature in currently available tools?