title: WITH in BigQuery
body: <p>Does BigQuery support the <code>WITH</code> clause? I don't like formatting too many subqueries.</p>
  
  <p>For example:</p>
  
  <pre><code>WITH alias_1 AS (SELECT foo1 c FROM bar)
  , alias_2 AS (SELECT foo2 c FROM bar a, alias_1 b WHERE b.c = a.c)
  SELECT * FROM alias_2 a;
  </code></pre>