Is your feature request related to a problem or challenge?

arrays_overlap function is supported by following query engines:
arrays_overlap: select arrays_overlap(array('hello', world'), array('hello')) => true
References:
Spark: https://docs.databricks.com/en/sql/language-manual/functions/arrays_overlap.html
Snowflake: https://docs.snowflake.com/en/sql-reference/functions/arrays_overlap
Presto: https://prestodb.io/docs/current/functions/array.html#arrays_overlap-x-y-boolean

Also, related DataFusion Comet PR: apache/datafusion-comet#1312

Describe the solution you'd like

DataFusion' s array_has_any function aims to have same behavior with arrays_overlap function and it can also be exposed as alias of legacy array_has_any function.

Describe alternatives you've considered

No response

Additional context

No response