Determining JSON types in BigQuery

Here's a mildly interesting function if you're working with JSON in BigQuery. JSON_TYPE takes in a JSON value and returns the name of the respective JSON type (object, array, string, number, boolean, null) as a STRING. See below an illustration of it...