Support JSON data type

[jlynchMicron]

Thanks for stopping by to let us know something could be better!

PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. This will ensure a timely response.

Is your feature request related to a problem? Please describe.
Described in the current source code: https://github.com/googleapis/python-bigquery-dataframes/blob/main/bigframes/dtypes.py#L83

[tswast]

Hello @jlynchMicron , thanks for the feedback. We are actively working on JSON support, for example by adding some JSON functions to the bigframes.bigquery package (see: https://cloud.google.com/python/docs/reference/bigframes/latest/bigframes.bigquery#bigframes_bigquery_json_set).

Based on the linked issue (googleapis/python-bigquery#1966), are you also looking for better I/O support for JSON, so that to_gbq can produce tables with JSON columns?