Comments
# /* Multi-line
comment */
Strings
"foo \"bar\" baz"
'foo \'bar\' baz'
"Multi-line strings
are supported"
'Multi-line strings
are supported'
Parameters
$1 $2 $3
Operators
SELECT 1 AND 1;
SELECT 1 OR NULL;
SELECT EXISTS 1;
SELECT 2 BETWEEN 1 AND 3;
Functions and keywords
SELECT COUNT(*) AS total, MAX(foo) AS max_foo
FROM `my_bucket`
WHERE `foo` IS NOT NULL;
CREATE INDEX productName_index1 ON bucket_name(productName, ProductID)
WHERE type="product" USING GSI
WITH {"nodes":["node1:8091", "node2:8091", "node3:8091"]};
Identifiers
SELECT *
FROM `my_bucket`;