Support AND operator as alias of list intersect/array intersect function like Duckdb

### Is your feature request related to a problem or challenge?

Support list intersect operators like Duckdb. https://duckdb.org/docs/sql/functions/nested

Example: [1,2,3] && [4,5] -> array_intersect([1,2,3], [4,5])

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Start by tracing DataFusion's existing array_intersect or list-intersection implementation and the SQL expression parser, using the DuckDB nested-functions reference linked in the issue for expected behavior. The work is done when && accepts two list values as an alias for array_intersect and tests cover the example [1,2,3] && [4,5].

Written by the indexing model from the issue text.