SQL++ Querying — PHP

SQL++ syntax reference: shared/server/sql-syntax.md — SELECT, JOINs, MERGE, window functions, built-in functions.

scope->query() vs cluster->query()

$scope->query() sets query_context automatically, so collection names in the SQL++ string don't need full bucket.scope.collection qualification — use bare collection names instead.

$cluster->query() requires fully-qualified keyspace paths (e.g. `travel-sample`.`inventory`.`airline`). Use it only when querying across multiple scopes or buckets in a single statement.

Basic Query

Prefer $scope->query() — sets query_context so collection names don't need full qualification.

use Couchbase\QueryOptions;

$scope = $cluster->bucket("travel-sample")->scope("inventory");