[FEATURE] - explore/keep eyes on BQ new JSON functions

[fivetran-jamie]

BQ introduced a native JSON data type (ala variants in snowflake maybe?) and some new JSON parsing functions. the ones we leverage in this package are now "legacy" in the docs https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions

let's keep eyes on this to see if theres any sort of deprecation

[fivetran-joemarkiewicz]

This will become ever more important once the Fivetran connectors start supporting native JSON datatypes in the individual warehouses.