Value construction functions SQL Function Description ROW(value1 [, value2]*) Also valid as an implicit row constructor using parenthesis alone. Returns a row created from a list of values (value1, value2, …). For example: Returns ROW(1 ,'FOO' ) (1 ,'FOO' ) The implicit row constructor requires at least two fields. The explicit row constructor can deal with an arbitrary number of fields. Both of them support arbitrary expressions as fields. ARRAY[ value1 [, value2 ]* ] Returns an array created from a list of values (value1, value2, …). For example: Returns ARRAY['A','B','C'] [A, B, C] MAP[ value1, value2 [, value3, value4 ]* ] Returns a map created from a list of key-value pairs ( (value1, value2), (value3, value4), … ). For example: Returns MAP['A','B','C','D'] {A=B, C=D}