←back to thread

Show HN: JSON Query

(jsonquerylang.org)
147 points wofo | 1 comments | | HN request time: 0.001s | source

I'm working on a tool that will probably involve querying JSON documents and I'm asking myself how to expose that functionality to my users.

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?

Show context
mrtimo ◴[] No.45725198[source]
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): >>45726748 #
1. zie ◴[] No.45726748[source]
So can postgres, I tend to just use PG, since I have instances running basically everywhere, even locally, but duckdb works well too.