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,…). The implicit row constructor supports arbitrary expressions as fields but requires at least two fields. For example: Returns ROW(1 ,'FOO' ) (1 ,'FOO' ) ARRAY[ value1 [, value2 ]* ] Returns an array created from a list of values. 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. For example: Returns MAP['A','B','C','D'] {A=B, C=D}