This reference guide explains the full syntax and semantics of the SQL++ Query Language, a SQL-inspired language for working with semistructured data. SQL++ has much in common with SQL, but there are also differences due to the data model that the language is designed to serve. SQL was designed in the 1970’s for interacting with the flat, schema-ified world of relational databases, while SQL++ is designed for the nested, schema-less/schema-optional world of modern NoSQL systems. In particular, SQL++ in the context of Analytics is intended for working with the JSON data model.
In the following sections, features of the SQL++ language are described in a grammar-guided manner with a brief description for each of the productions in the SQL++ grammar offering examples with results for clarity.