JSONiq


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. JSONiq comes in two syntactical flavors, which both support JSON and XML natively.
  1. The JSONiq syntax extended with XML support through a compatible subset of XQuery.
  2. The XQuery syntax extended with JSON support through a compatible subset of the above JSONiq syntax.

    Features

JSONiq primarily provides means to extract and transform data from JSON documents or any data source that can be viewed as JSON.
The major expression for performing such operations is the SQL-like “FLWOR expression” that comes from XQuery. A FLWOR expression is constructed from the five clauses after which it is named: FOR, LET, WHERE, ORDER BY, RETURN. However, it also supports clauses for doing grouping and windowing.
The language also provides syntax for constructing new JSON documents where either the field names and values are known in advance or can be computed dynamically. The JSONiq language is a superset of JSON. That is, each JSON document is a valid JSONiq program.
Additionally, the language also supports a navigational syntax for extracting field names and values out of JSON objects as well as values out of JSON arrays. Navigation is resilient in the absence of values, or if values are heterogeneous, in that it silently ignores unforeseen values without raising errors.
All constructs are defined as expressions within the language and can be arbitrarily nested.
JSONiq does not include features for updating JSON or XML documents, it does not have full text search capabilities, and has no statements. All of these features are under active development for a subsequent version of the language.
JSONiq is a programming language that can express arbitrary JSON to JSON or XML to XML transformations. It also allows for transformations between JSON and XML. All such transformations have the following features:
  1. Logical/physical data independence
  2. Declarative
  3. High level
  4. Side-effect free
  5. Strongly typed

    Data model

The language is based on the JSONiq Data Model which is an extension of the XQuery and XPath Data Model. The JDM uses a tree-structured model of the information content of a JSON or XML document. It contains JSON objects, JSON arrays, all kinds of XML nodes, as well as atomic values such as integers, strings, or boolean all being defined in XML Schema.
JDM forms the basis for a set-oriented language, in that instances of the data model are sequences. The items in a sequence can be JSON objects, JSON arrays, XML nodes, or atomic values.

Examples

The sample JSONiq code below computes the area code and the number of all people older than 20 from a collection of JSON person objects.

for $p in collection
where $p.age gt 20
let $home := $p.phoneNumber.number
group by $area := substring-before
return


All JSONiq constructs are expressions and can also be contained in the body of a function.

declare function local:adults
;

The next query transforms parts of each person object into an XML element using the XQuery syntax.

for $p in collection
return





Applications

Below are a few examples of how and where JSONiq can be used:
  1. Extracting information out of a database to use in a web service.
  2. Generating summary reports on data stored in a JSON document store.
  3. Selecting and transforming JSON data to XHTML to be published on the Web.
  4. Correlating data from various sources and formats and offer it in a web service.
  5. Transforming collections of JSON objects into a different schema.

    Comparison of the two syntactic flavors

There are two syntaxes of JSONiq, which users can use on whether they are focusing on JSON or XML.
Both syntaxes use the same data model and are very similar up to a few exceptions.

JSONiq syntax

The pure JSONiq syntax is a superset of JSON. It is not strictly speaking a superset of XQuery even though all its expressions and semantics are available.
The following aspects of the JSONiq syntax are not XQuery conformant:
  1. No names containing dots.
  2. No. for the context item.
  3. No single-quoted literals.
  4. JSON, backslash-based escaping in string literals.
  5. No axis step allowed at the beginning of a relative path expression.

    XQuery syntax with JSONiq extension

The JSONiq extension to XQuery is a superset of XQuery but not a superset of JSON. It is fully conformant and backwards compatible with XQuery 3.0 candidate recommendation.
The following aspects of JSONiq are not supported in the XQuery syntax.
  1. No dot-based object lookup.
  2. No $$ for the context item.
  3. XML, ampersand-based escaping of string literals.
  4. Object keys must be quoted
  5. No true/false/null literals
  6. Built-in atomic types must be prefixed with xs:.
  7. Non-atomic types must be followed by parentheses.
  8. The empty-sequence must be written as such.
  9. No array lookup and no array unboxing.

    Implementations