Investigate reworking bigquery table schema field

[c2thorn]

Affected Resource(s)

• google_bigquery_table

The schema field in bigquery table has caused quite a few issues lately:

#8337
#8503

Mostly around drift detection and Terraform attempting to force recreate the table based on the field changes. Instead of applying bandaids to the growing custom logic, we should seriously consider an overhaul of the field in general.

b/340204339