yql/essentials/tests/sql/suites/flatten_by/flatten_columns.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
USE plato;

SELECT * FROM (
SELECT
    AsStruct(key as key, subkey as subkey),
    AsStruct("value: " || value as value)
FROM Input
)
FLATTEN COLUMNS;