[Feature]: Support ALL, ANY for Array types

Is there an existing issue for this?

• I have searched the existing issues

Is your feature request related to a problem? Please describe.

SELECT ProductName FROM Products WHERE ProductID = ANY,ALL (LISTType); ALL = equals to any element in ListType != not equal to any element in ListType

larger than the smallest value in list < smaller than the largest value in list

ALL = equals to all elements in ListType != not equal to at least one element in ListType

larger than the largest value in list < smaller than the smalled value in list

Describe the solution you'd like.

No response

Describe an alternate solution.

No response

Anything else? (Additional Context)

No response