SQL++ Querying — Ruby

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

Basic Query

Prefer scope.query — sets query_context so collection names don't need full qualification.

scope = cluster.bucket("travel-sample").scope("inventory")

result = scope.query("SELECT * FROM `airline` LIMIT 10")
result.rows.each { |row| puts row.inspect }

Parameterized Queries

Always use parameters — never interpolate user input into query strings.