JSONiq - Query language

JSONiq is a query language created in 2011.

#940on PLDB

13Years Old

153Repos

JSONiq is a query and functional programming language that is designed to declaratively query and transform collections of hierarchical and heterogeneous data in format of JSON, XML, as well as unstructured, textual data. JSONiq is an open specification published under the Creative Commons Attribution-ShareAlike 3.0 license. It is based on the XQuery language, with which it shares the same core expressions and operations on atomic types. Read more on Wikipedia...

Tags: queryLanguage
There are at least 153 JSONiq repos on GitHub
JSONiq is a superset of JSON
Early development of JSONiq happened in https://groups.google.com/g/zorba-io-user
The Google BigQuery Public Dataset GitHub snapshot shows 386 users using JSONiq in 423 repos on GitHub
GitHub supports syntax highlighting for JSONiq
jsoniq.org was registered in 2011
See also: (5 related languages) XQuery, SQL, JSON, XML, ISBN

Example from hello-world:

"Hello World"

Example from Linguist:

(: Query for returning one database entry :)

import module namespace req = "http://www.28msec.com/modules/http-request";
import module namespace catalog = "http://guide.com/catalog";

variable $id := (req:param-values("id"), "London")[1];
variable $part := (req:param-values("part"), "main")[1];

catalog:get-data-by-key($id, $part)

Example from Wikipedia:

for $p in collection("persons")
 return
   <person>
     <firstName>{$p("firstName")}</firstName>
     <lastName>{$p("lastName")}</lastName>
     <age>{$p("age")}</age>
   </person>

Language features

Feature	Supported	Example	Token
Strings	✓	"Hello world"	"