Although Cirro is generally SQL-92 compliant, this document is the authoritative source for the Cirro SQL language. Cirro supports standard SQL-92 commands unless stated.

Audience

Users of this information should:

  • Have a basic understanding of the SQL92 standard and relational databases.

  • Understand which of their data sources are available through Cirro.

  • Know how to use a SQL client to connect to Cirro. See the Cirro BI User Guide and the Cirro Analyst User Guide for information.

Cirro Query Execution and Federated Systems

When executing queries on federated systems, the behaviors of the underlying database are dominant regarding how results are calculated.

Identifiers and Reserved Words

These words are reserved in either Cirro or the SQL-92 standard and should not be used as identifier names.

SQL Guide Index

You can find all SQL commands in the index.