BigQuery: is there a generic function which extracts & converts a scalar value in json
I'm starting working on json columns in google bigquery. My aim is to implement a query which: extracts a given value in the json object based on path and returns its real SQL value. Example: given {"foo": {"bar": 123}}, I'd…