Well BigQuery's SQL dialect is quite extensive and constantly evolving with new features and functions. Just like you mentioned, I think the workaround for this one is using sqlparse library in python as it can parse SQL statements into an abstract syntax tree. You could use this to analyze BigQuery queries and perform some transformations. It's not perfect and might not handle all edge cases, but it's a practical option for many tasks.