yql/essentials/tests/sql/suites/action/subquery.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

/* 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();