Show HN: MistQL, a mini-language for querying JSON-like structures

I love it but I do wonder if there is anything out there that is syntactically similar to SQL for querying JSON.

Very cool. Going to play with this. Thank you! I couldn’t wrap my head around jq so this is lovely.

This is pretty sweet! I always have to look up jq docs if I want to do anything complex, but your pipe model seems more intuitive. Also, I love that there's both a library and a CLI.

The comparison section should probably include JSONPath, which for example PostgreSQL uses for this.

i dont really like the pipes as a model<p>but congratulations on working to break out of the existing flawed paradigms like sql. at least you have composition.

I think some SQL subset for json would just suffice...easy to read and well known as well.