I did a lot of work on the BigQuery SQLAlchemy dialect on 2021.

(I needed a BigQuery connection to develop/test that. 😄 )

I leaned heavily on theSQLAlchemy Dialect Compliance test suite.

It doesn't look like y'all are using the compliance suite. It might be a good way to provide a lot more testing of your dialect.

FWIW.