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


1
2
3
4
5
6
7
8

/* syntax version 1 */
/* postgres can not */

define subquery $foo() as
  select <|a: 1, b: 2|> as s;
end define;

select s.a as a, s.b as b from $foo();