SQL++ Querying — Python

Basic Query

from couchbase.options import QueryOptions

result = cluster.query(
    "SELECT META().id, o.status, o.total FROM `myapp`._default.orders o WHERE o.status = $status LIMIT 10",
    QueryOptions(named_parameters={"status": "pending"})
)
for row in result:
    print(row)

Always use named parameters ($name) or positional parameters ($1) — never string-format user input into queries.

Positional Parameters