title: bigquery - partition on custom fields -- only for standardSQL?
body: <p>I just saw that I can create a <code>custom partitioned</code> table in BigQuery. Meaning partitioned by any <code>timestamp</code> column.</p>
  
  <p><strong>However</strong>, the newly created table can only be accessed and queried from <code>StandardSQL</code>!</p>
  
  <p>Is there a way to query the new tables from Legacy?</p>
  
  <p><a href="https://i.stack.imgur.com/zPj8z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zPj8z.png" alt="enter image description here"></a></p>