title: How to convert stringified array into array in BigQuery?
body: <p>It so happens I have a stringified array in a field in BigQuery</p>
  <pre><code>'[&quot;a&quot;,&quot;b&quot;,&quot;c&quot;]'
  </code></pre>
  <p>and I want to convert it to an array that BigQuery understands.
  I want to be able to do this in standard SQL:</p>
  <pre><code>with k as (select '[&quot;a&quot;,&quot;b&quot;,&quot;c&quot;]' as x)
  select unnested_x from k, unnest(x) unnested_x
  </code></pre>
  <p>I have tried <code>JSON_EXTRACT('[&quot;a&quot;,&quot;b&quot;,&quot;c&quot;]','$')</code> and everything else I could find online.</p>
  <p>Any ideas?</p>