Implement array_has_all function #6973
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_has_all |
| Aliases: | list_has_all, @>, <@ |
| Original function?: | No |
| Function Description: | Clickhouse: Checks whether one array is a subset of another. DuckDB: Returns true if all elements of sub-list exist in list. |
| Sources: | Concept ClickHouse DuckDB |
Examples:
select array_has_all([1, 2, 3, 4], [3, 4]);
----
true
select array_has_all([1, 2, 3, 4], [5, 4]);
----
false
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
#6972
No response