Invalid JSON Path _id.$oid bigquery

Question

I have this JSON data in a BigQuery column:

SELECT JSON '{"$oid":"123"}'

How can I get the $oid value?

Expected output: 123

Answer 1

  SELECT JSON_QUERY(JSON '{"$oid":"123"}', '$."$oid"')