Couchbase N1QL WHERE…IN
Couchbase query language N1QL is very annoying when it comes to
WHERE...IN clause. I find it very odd that it decided to go different than RBDMS SQL queries, and require square brackets
["value1", "value2"] instead of the round brackets that are so common pretty much in every tool (and for DB people: in RDBMS SQL).
A full functioning example for Couchbase N1QL:
SELECT fields FROM bucket WHERE field IN ["value1", "value2", ...]
And the following example will not work:
SELECT fields FROM bucketWithBadQuery WHERE fieldWithBadWhere IN ("value1", "value2", ...)
By the way, I came across this when I tried doing a nice query that additionally does
SELECT COUNT(*) ... GROUP BY field and
SELECT parentNode.field FROM bucket UNNEST bucket.parentNode AS parentNode for the first time, and integrating all those clauses together needed some extra effort.