ydb/yt/yql/tests/sql/suites/action/subquery.sql

/* syntax version 1 */
/* postgres can not */
use plato;

define subquery $q($name, $a) as
    $i = (select * from $name);
    $b = "_foo";
    select key || $a || $b as key from $i;
end define;

$z = (select key from $q("Input", "_bar"));

select $z;

select key from $q("Input", "_baz") order by key;

define subquery $e() as
    select "hello";
end define;

process $e();