JSON_EXTRACT in BigQuery Standard SQL?
<p>I'm converting some SQL code from BigQuery to BigQuery Standard SQL.</p>

<p>I can't seem to find JSON_EXTRACT_SCALAR in Bigquery Standard SQL, is there an equivalent?</p>