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
  • CREATE/DROP Statements
  • ALTER syntax for any
• DCL Statements/Procedural Language/BigQuery ML
• Pre-GA features

References

• ZetaSQL: https://github.com/google/zetasql/blob/master/docs/README.md
• Other SQL Projects :
  • https://github.com/m-novikov/tree-sitter-sql
  • https://github.com/DerekStride/tree-sitter-sql
  • https://github.com/dhcmrlchtdj/tree-sitter-sqlite

Development

Running tests

npm install --also=dev
npm test

Debbuging

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