New array method array_contains #6557

Is your feature request related to a problem or challenge?

Follow on to #6384

The function array_contains was proposed @bubbajoe in #6075.

Describe the solution you'd like

We have two arrays: first_array and second_array.
The main concept of the function is to check all elements of first_array for presence in second_array (dimensions and iorder of elements do not affect the result).

Examples:

select array_contains(make_array(1, 4, 3), make_array(3, 1, 3));
----
t

Describe alternatives you've considered

We can use PostgreSQL operations for checking elements of first array in second array (See https://www.postgresql.org/docs/current/functions-array.html):

select make_array(1, 4, 3) @> array(3, 1, 3);
----
t

select make_array(2, 2, 7) <@ make_array(1, 7, 4, 2, 6);
----
t

We can use array_contains for only one element (like contains method in Rust), but I think it would be better to use the check elements of the first array in the second array (But the idea to use two options is not refuted)

Additional context

Similar Issues:
#6075

Similar PR:
#6384