Function to create arrays from several fields

[alexfacciorusso]

Is your feature request related to a problem? Please describe.

It is frustrating using concatenate to get fields and joining them together. There is already a join function, but there is no function to create an array (or at least, it is not documented or not easily explorable?).

Describe the solution you'd like

It would be nice doing something like

array_join( [{Name}, {Surname}, {Age}, {Something Else}], " ")

so that many fields can be concatenated with a same divider. The current alternative would be:

concatenate({Name}, " ", {Surname}, " ", {Age}, " ", {Something Else})

not only that, but it would help with almost impossible (or very complicated) situations like empty and null items (using ARRAY_COMPACT) and other similar ones.