Implement support for the array type and array operators in WHERE clauses #1767
Description
Consult Postgres docs for the list of available operators and their semantics - https://www.postgresql.org/docs/current/functions-array.html#ARRAY-OPERATORS-TABLE.
We are primarily interested in operators that check for element inclusion and subarray containment:
-
anyarray @> anyarray → boolean -
anyarray <@ anyarray → boolean -
anyarray && anyarray → boolean
Implementing this issue will also close this feature request.
Most recent additions to WHERE clauses was concerning boolean predicates - #1441.