SQL++ Querying — Java

Basic Query

import com.couchbase.client.java.query.QueryOptions;
import com.couchbase.client.java.query.QueryResult;

QueryResult result = cluster.query(
    "SELECT META().id, o.status, o.total FROM `myapp`._default.orders o WHERE o.status = $status LIMIT 10",
    QueryOptions.queryOptions()
        .parameters(JsonObject.create().put("status", "pending"))
);
result.rowsAsObject().forEach(row -> System.out.println(row));

Positional Parameters