WITH in BigQuery

Recently introduced BigQuery Standard SQL does support WITH clause
See more about WITH clause

See also how to Enabling Standard SQL

BigQery Standard SQL is supporting WITH clause. The syntax is as shown below

with table2 as (Select column1,column2 from table1)
    select column1 from table2