Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

sql-dialect-fmt

sql-dialect-fmt is an opinionated Rust formatter and editor toolchain for Snowflake SQL and Databricks SQL. It is built around a lossless lexer/parser pipeline: unsupported or malformed input is preserved, comments survive formatting, and repeated formatting is stable.

Use the playground to run the WebAssembly formatter in the browser, or install the CLI for local and CI usage.

cargo install sql-dialect-fmt --version 1.22.3 --locked
sql-dialect-fmt --check sql/**/*.sql
sql-dialect-fmt --write sql/**/*.sql

Coverage

  • Snowflake SELECT, DML, COPY, major DDL and object DDL.
  • Snowflake Scripting and routine bodies in SQL, JavaScript, Python, Java, and Scala.
  • Databricks mode for backtick identifiers, LATERAL VIEW, Delta DDL options, time travel, higher-order function lambdas, and SQL scripting blocks.
  • LSP, semantic tokens, hover text, and a bundled VS Code/WASM extension. Tree-sitter work is retained but paused outside the active workspace and CI.

The detailed tracker lives in spec/seed/features.json; run:

python3 spec/snowflake_spec.py coverage