Introduction

CouchDB is not an RDBMS, and while CouchQL attempts to make it easier to use by providing a familiar, SQL-like interface it cannot support the complete SQL standard. Trying to run some SQL queries will work while others will give you terrible performance and some will just fail.

Supported SQL syntax

Currently CouchQL only supports the SQL queries in the following formats...

SELECT * FROM db_name
SELECT * FROM db_name WHERE expr

CouchQL doesn't support queries which return a subset of columns, nor does it support multiple expressions in the WHERE clause. CouchQL currently only supports the operators =, <= and >= in expressions.