How can I convert JSON keys to columns and values to rows in BigQuery?

How can I convert JSON keys to columns and values to rows in BigQuery?

More to explore

Based on this image's title: “How can I convert JSON keys to columns and values to rows in BigQuery?