SQL Connector

The SQL Connector feature of the connector allows applications to use normal SQL queries against Couchbase Server, translating standard SQL-92 queries into equivalent N1QL client API calls. This translation allows standard queries that BI tools execute to run against your Couchbase Server instance. If a query cannot be fully translated, then the translated parts of the query are passed down as one or more N1QL queries to the Couchbase Server instance for processing while the untranslated parts of the query are processed by Simba SQL Engine.

Important:

When specifying the names of data structures such as tables, columns, or buckets in queries, make sure that the letter case of the name in the query matches the letter case of the name in the Couchbase database. Names of data structures are case-sensitive in Couchbase. For example, if you try to execute a SQL query against a "product" table but the name of the bucket in Couchbase is "Product", the query will fail.

Data Types
Features
Query Mode
Configuring the Driver on page 1