N1QL SELECT

N1QL (SQL for JSON) SELECT queries documents with full SQL syntax including WHERE, JOIN, GROUP BY, and UNNEST for arrays.

Syntax

couchbase

SELECT fields FROM bucket WHERE condition;

Example

couchbase

SELECT name, email FROM users WHERE tier = 'premium';

-- UNNEST array elements
SELECT u.name, t AS tag
FROM users u
UNNEST u.interests AS t;

-- Parameterized in Node.js
const result = await cluster.query(
  "SELECT * FROM users WHERE tier = $1",
  { parameters: ['premium'] }
);