title: JSON_EXTRACT in BigQuery Standard SQL?
body: <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>