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

• [x] Basic Literals/Expressions
• [x] Query Statement
• [x] DML Statements
• [ ] DDL Statements
  • [x] 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