Compass SQL Reference

Each SQL query is based on a single JSON or DSV custom document. Joins are not supported.

The object names are not case-sensitive. For example, an object schema named Customer may be queried as Customer or customer.

Property names are case-sensitive. For example, a property name of ProductID must be selected in a query as “select ProductID”.

Use double quotes if the object name or property name includes spaces. Double quotes are not required if the object or property name includes underscores. Object or property names that begin with a digit must be enclosed within double quotes. Enclose property names that are SQL reserved words with double quotes.