search

googleapis / python-bigquery-sqlalchemy

SQLAlchemy dialect for BigQuery
MIT License
436 stars 130 forks source link

Support JSON types #546

Open pythonruss opened 1 year ago

pythonruss commented 1 year ago

Bigquery standard sql supports a json column type link

it is not supported as a dialect type in this package link

I'm sure many users will have a need for a nested column with no predefined schema, struct doesn't cover flexible nested records

sachsbl commented 1 year ago

+1

caffeinatedMike commented 1 year ago

This is a need for me as well. Having to coerce column values after-the-fact (json.loads) is not obvious at first glance and shouldn't be necessary for a DB-API where the proper types are supported in the underlying DB flavor (BigQuery Standard).

jlynchMicron commented 1 year ago

Duplicate: https://github.com/googleapis/python-bigquery-sqlalchemy/issues/399

mephmanx commented 1 year ago

I also need JSON column types

or-asher commented 1 year ago

I also really need this feature, is there any plans to implement this soon?

veejar commented 7 months ago

Also want to request this feature.

Ishankoradia commented 1 month ago

any news on this, i also need this.