tree-sitter for BigQuery's SQL

This project supports StandardSQL in BigQuery. You could try out the demo on Github Pages

Supported BigQuery SQL feature

• Basic Literals/Expressions
• Query Statement
• DML Statements
• DDL Statements
• Procedural Language
• BigQuery ML
• DCL Statements

References

• ZetaSQL: https://github.com/google/zetasql/blob/master/docs/README.md

• Other SQL Dialect Projects:

  • MySQL: https://github.com/DerekStride/tree-sitter-sql
  • PostgreSQL: https://github.com/m-novikov/tree-sitter-sql
  • SQLite: https://github.com/dhcmrlchtdj/tree-sitter-sqlite

Development

Running tests

npm install --also=dev
npm test

Debbuging

• npm run parse <your sql file.sql> outputs a syntax tree