How to create JSON Datatype in BigQuery?

Summary

BigQuery recognizes JSON as a standalone data type, not merely a string. JSON values can be expressed in multiple ways: using JSON literal, parsing a json-like string with JSON_PARSE(), forming a JSON object from key-value pairs with JSON_OBJECT(), and creating a JSON_ARRAY() from a BigQuery ARRAY. These techniques enable the use of JSON functions and storing diverse data in one column.