JSON_EXTRACT in BigQuery Standard SQL?

Question

I'm converting some SQL code from BigQuery to BigQuery Standard SQL.

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

Answer 1

Edit: we implemented the JSON functions a while back. You can read about them in the documentation.