How to convert stringified array into array in BigQuery? : <p>It so happens I have a stringified array in a field in BigQuery</p>

<pre><code>'["a","b","c"]'
</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 '["a","b","c"]' as x)
select x from k, unnest(x) x
</code></pre>

<p>I have tried <code>JSON_EXTRACT('["a","b","c"]','$')</code> and everythig else I could find online.</p>

<p>Any ideas?</p>
