with clauses

with can be used to create an ephemeral view that lasts as long as the query.

source