ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the provided expression arguments. All arguments must be of the same type. ARRAY_APPEND(arr, expr) Appends the expression to the array. The ...
The docs say that SQL MV_* functions all work on arrays: All 'array' references in the multi-value string function documentation can refer to multi-value string columns or ARRAY literals. But it isn't ...