Array containment operator #6884

Is your feature request related to a problem or challenge?

Like other popular databases (DuckDB, PostgreSQL) it would be better to support some operators for working with arrays, making life easier for the user. The most popular operator is array containment operator which check a subset belongs to a set (in other words, the operator is alias of array_has_all function).

There are two options:

• @> (equals to array_has_all(array1, array2)
• <@ (equals to array_has_all(array2, array1)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response