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.

Who should use this guide?

You'll need a basic understanding of the SQL92 standard and relational databases.

Before you start

Check the basic setup steps have been completed, including adding your Datasources.

Basic Setup

Setup SQL Client

Connect to Oracle, SQL-Server, or databases that use the MySQL or Postgres wire protocol.

Direct Connect

Connect to Cirro using ODBC or JDBC drivers and perform Federated queries across your databases.

ODBC and JDBC SQL Clients

You can also use Cirro's built-in Federated Query Builder.

Federated Query Builder

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.

Identifiers and reserved words

SQL Syntax Notation

The Cirro SQL Guide uses a standard syntax notation.

Syntax Notation

Cirro SQL

Use the SQL guide index to find the SQL you're looking for:

SQL Guide Index

Or go direct to the category pages:

Data Types


Cirro Hints