DuckDB can read JSON - you can query JSON with normal SQL.[1]
I prefer to Malloy Data language for querying as it is 10x simpler than SQL.[2]
[1] - https://duckdb.org/docs/stable/data/json/overview [2] - https://www.malloydata.dev/
replies(1):
I like the power of `jq` and the fact that LLMs are proficient at it, but I find it right out impossible to come up with the right `jq` incantations myself. Has anyone here been in a similar situation? Which tool / language did you end up exposing to your users?
[1] - https://duckdb.org/docs/stable/data/json/overview [2] - https://www.malloydata.dev/