Description
Ref: https://prestodb.io/docs/current/functions/array.html
Merges the given arrays, element-wise, into a single array of rows. The M-th element of the N-th argument will be the N-th field of the M-th output element. If the arguments have an uneven length, missing values are filled with NULL.
SELECT array_zip(ARRAY[1, 2], ARRAY['1b', null, '3b']); -- [ROW(1, '1b'), ROW(2, null), ROW(null, '3b')]
Note: while Presto's function name is zip, we used array_zip as name. For details please check the discussion in the PR.