Is there a (roughly) SQL or XQuery-like language for querying JSON?

I&#39;m thinking of very small datasets that map nicely to JSON where it would be nice to easily answer queries such as &quot;what are all the values of X where Y &gt; 3&quot; or to do the usual SUM / COUNT type operations.

As completely made-up example, something like this:

    [{&quot;x&quot;: 2, &quot;y&quot;: 0}}, {&quot;x&quot;: 3, &quot;y&quot;: 1}, {&quot;x&quot;: 4, &quot;y&quot;: 1}]
    
    SUM(X) WHERE Y &gt; 0     (would equate to 7)
    LIST(X) WHERE Y &gt; 0    (would equate to [3,4])

I&#39;m thinking this would work both client-side and server-side with results being converted to the appropriate language-specific data structure (or perhaps kept as JSON)

A quick Googling suggests that people have thought about it and implemented a few things ([JAQL][1]), but it doesn&#39;t seem like a standard usage or set of libraries has emerged yet. While each function is fairly trivial to implement on its own, if someone has already done it right I don&#39;t want to re-invent the wheel.

Any suggestions?

Edit: This may indeed be a bad idea or JSON may be too generic a format for what I&#39;m thinking.. The reason for wanting a query language instead of just doing the summing/etc functions directly as needed is that I hope to build the queries dynamically based on user-input. Kinda like the argument that &quot;we don&#39;t need SQL, we can just write the functions we need&quot;. Eventually that either gets out of hand or you end up writing your own version of SQL as you push it further and further. (Okay, I know that is a bit of a silly argument, but you get the idea..)


  [1]: http://www.jaql.org/release/0.1/jaql-overview.html

All Dynamic Queries Solutions on Gang of Coders

Total of 1 Dynamic Queries Solutions

Is there a query language for JSON?