Is your feature request related to a problem or challenge?

Hello,

I have an array data type and i would like to be able to run the following functions.

Describe the solution you'd like

array_length(col)
array_contains(col, T) AND/OR select * from my_table where 'text'=ANY(my_col);
array_unnest()

# TABLE
| food | ingredients          |
| ---- | -------------------- |
| user | [eggs, salt, pepper] |

# SQL INPUT
# SELECT food, unnest(ingredients) from TABLE

# SQL OUTPUT
| food | unnest(ingredients) |
| ---- | ------------------- |
| user | eggs                |
| user | pepper              |
| user | salt                |

Describe alternatives you've considered

No response

Additional context

No response