Implement `array_has_any` function

[izveigor]

Is your feature request related to a problem or challenge?

Summary

Characteristic	Description
Function name:	array_has_any
Aliases:	list_has_any
Original function?:	No
Function Description:	PostgreSQL: Do the arrays overlap, that is, have any elements in common? Azure DataBricks: Returns true if the intersection of array1 and array2 is not empty. Clickhouse: Checks whether two arrays have intersection by some elements. DuckDB: Returns true if any elements exist is both lists.
Sources:	Concept PostgreSQL Azure ClickHouse DuckDB

Examples:

select has_any([1, 2, 3, 4], [3, 5, 6]);
----
true

select has_any([1, 5, 3, 4], [2, 6]);
----
false

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response