yql/essentials/tests/sql/suites/simple_columns/simple_columns_subreq.sql


1
2
3
4
5
6
7
8
9

/* postgres can not */
PRAGMA SimpleColumns;

USE plato;

$req = (SELECT 100500 as magic, t.* FROM Input as t);

--INSERT INTO Output
SELECT subkey as sk, value as val FROM $req ORDER BY sk