←back to thread

Show HN: JSON Query

(jsonquerylang.org)
147 points wofo | 3 comments | 27 Oct 25 16:22 UTC | HN request time: 0s | 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?

1. peterohler ◴[27 Oct 25 18:59 UTC] No.45724931[source]▶
If you prefer JSONPath as a query language, oj from https://github.com/ohler55/ojg provides that functionality. It can also be installed with brew. (disclaimer, I'm the author of OjG)
replies(1): >>45725101 #
2. tyre ◴[27 Oct 25 19:13 UTC] No.45725101[source]▶
JSONPath is also supported by Postgres!

Helpful when querying JSON API responses that are parsed and persisted for normal, relational uses. Sometimes you want to query data that you weren’t initially parsing or that matches a fix to reprocess.

replies(1): >>45725344 #
3. Eric_WVGG ◴[27 Oct 25 19:36 UTC] No.45725344[source]▶
speaking of classic databases: can anyone explain to me, a dummy, why any syntax like this or even GraphQL is preferable to "select a.name, a.age from friends a where a.city = 'New York' order by a.age asc"?