I am doing this already for an internal tool that accesses a bigquery data warehouse. Long term this will be a feature my company sells.
I will not open source it since it is a paid feature, but I use sqlglot for most of the query parsing, validating and rewriting.