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.

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

Change Query Delimiter

Use DELIMITER to change the delimiter from the default semicolon ';' to any non-reserved character. It must be followed by a valid SQL query.

Change Delimiter

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

Functions

Cirro Hints

Operators

Privileges

Statements