Portable BigQuery SQL Parser available in many programming language such as Rust, Node and so on.
This project supports StandardSQL in BigQuery. You could try out the demo on Github Pages
ZetaSQL: https://github.com/google/zetasql/blob/master/docs/README.md
Other SQL Dialect Projects:
npm install --also=dev
npm test
npm run parse <your sql file.sql>
outputs a syntax tree