There is a need for implementing an UNNEST(array) function that could be given in the select list so that we can replicate Postgres functionality that has the very same.
Considering the following table:
with this data:
A sample query would look like this:
Not that the expected is to 'zip' the arrays instead of joining their values to have the same behaviour as Postgres 10+.