[FEATURE] - Support for BigQuery JSON and Redshift SUPER datatypes

Currently all our JSON macros in this package are built under the assumption that the JSON fields are strings formatted as JSON. However, it has come to our attention that there may be JSON datatypes in BigQuery and SUPER in Redshift that are not strings and could cause potential issues in the macros within this package.

Therefore, we should update this package to have the macros allow for the handling of these new datatypes.