Engine supports the execution of SQL-like queries via its own query language, NSQL.
NSQL has many features in common with ANSI-SQL as well some extensions to improve its use for data analysis. It does not support all features of ANSI-SQL. The result that is generated from an NSQL query depends on the type of query that has been executed.
It is possible to generate the following result types:
- Domains (Recordsets - generated from Select statements)
- Single column values (generated from aggregate calculations)
- Sheets (tabular results - generated from GROUP By statements)
Domain and Sheet results are always "owned" by a table. The values that they contain relate to the records in a particular table.
NSQL statements must be terminated by a semi-colon (;)
Queries can be executed from AMC, iLoader, or using the NSQL Tool in Campaign Manager.
Data for TEXT columns must be included inside single or double quotation marks, e.g. "F" or 'F'.