title: Big Query INSERT INTO with WITH Clause giving error
body: <p>I am trying to insert data into Big Query Table.
  My query is complex and involves with clause, it is throwing error for all combinations I can try. I have written similar query in Hive and that works like charm.</p>
  <p>Any suggestion on how can I achieve this is higly appreciated:</p>
  <pre><code>bq query --use_legacy_sql=false \
  'with mapping_table as (SELECT t1.a, t2.b, t2.c from table1 as t1 inner join table2 on t2 group by ) 
  INSERT OVERWRITE TABLE my-bq-dev.myschema.mytable PARTITION(CREATE_DT) 
  SELECT A, B, C ...... from TABLEX LEFT OUTER JOIN TABLEY ON'
  </code></pre>
  <p><strong>Note</strong> the error is not related to syntax as My above query without INSERT OVERWRITE is working fine.</p>