Comment by chrstr

  create table x as (select * from person);
  select name from x where ...;

there you go, just configure your editor to display "create table x" as "declare x = " ;)

or even a version with lazy evaluation:

  create view x as (select * from person);
  select name from x where ...;