title: How to get an array from json?
body: <p>How would I do the following in BigQuery:</p>
  <pre><code>SELECT CAST(JSON '[1, 2]' AS ARRAY&lt;INTEGER&gt;)
  </code></pre>
  <blockquote>
  <p>Invalid cast from JSON to ARRAY at [1:13]</p>
  </blockquote>
  <p>JSON is so much more difficult to work with than the normal types in BQ!</p>