Postgres TOTD: Subqueries can be used almost everywhere: select (select 1) as c from (select 1) t where 1 = (select 1) limit (select 1);
0
0
0
0
0