/* postgres can not */ $data = AsList( AsStruct(1u AS Key, "v1" AS Value1, 100 AS Value2), AsStruct(2u AS Key, "v2" AS Value1, 200 AS Value2), AsStruct(3u AS Key, "v3" AS Value1, 300 AS Value2)); SELECT Key, Value2 FROM AS_TABLE($data); $input = ( SELECT * FROM AS_TABLE($data) WHERE Key > 1 ); SELECT Key, Value1 FROM $input;