JSONiq fully support XQuery language, with the help of JSONiq we can write a queries which can run on JSON, XML and HTML. JSON expression perform SQL like operations like FOR, LET, WHERE, GROUP BY and SELECT.
JSONiq supports JSON to JSON transformations. JSONiq is licensed under the Creative Commons Attribution-ShareAlike 3.0 License.
See following JSONiq example:
Zorba: JSONiq and JSONiq Extension to XQuery
BeniBela Internet Tools: JSONiq extension to XQuery
Website – http://www.jsoniq.org/