a sql linter that lints like rust, ships like a binary.

$ cat reports.sql
select * from users u join orders o on u.id=o.user_id
 where lower(u.email) like '%@oldcorp.com' order by u.id desc;
update orders set status='cancelled' where amount<0;

// 3 lines · 3 statements · waiting for drift

$ drift check reports.sql
reports.sql:1:1   warning  [drift.performance.select-star]
reports.sql:1:22  warning  [drift.style.keyword-case]
reports.sql:2:2   info     [drift.performance.fn-on-column]
reports.sql:2:31  warning  [drift.performance.like-leading-wildcard]
reports.sql:3:1   error    [drift.correctness.missing-where-guard]

────────────────────────────────────────────
5 issues · 1 error · 4 warnings      270ms

$ drift fix reports.sql
fixed reports.sql (3 safe rewrites applied, 2 left for you)

SELECT * FROM users u JOIN orders o ON u.id=o.user_id
 WHERE LOWER(u.email) LIKE '%@oldcorp.com' ORDER BY u.id DESC;
UPDATE orders SET status='cancelled' WHERE amount<0;

// keyword-case · normalized
// select-star  · still yours. not safe to auto-rewrite
// missing-where-guard · still yours. will not guess intent

$ drift rules | head -20
style        20 rules  · keyword case, indent, comma style, alias quoting
correctness  15 rules  · missing where, cartesian join, null compare
performance   8 rules  · select *, like wildcards, fn on indexed column
security      6 rules  · plaintext passwords, grant all, superuser ddl
portability   8 rules  · dialect-specific syntax, non-standard casts
conventions   8 rules  · snake_case columns, singular table names
ambiguity     5 rules  · unqualified columns, duplicate aliases

70 rules total. each one has a doc page and a 'why'.
run `drift explain <rule-id>` for the full writeup.

$ drift lsp &
[lsp] listening on stdio
[lsp] workspace root: ~/src/reports
[lsp] loaded drift.toml (dialect = postgres)

→ helix · neovim · vscode · zed
→ real-time diagnostics on save + on type
→ quick-fixes wired through code actions
→ all 70 rules available in the editor

// not a wrapper. speaks lsp 3.17 over stdio.

$ drift --version
drift 0.16.0 (2.9mb, stripped, static)

# dialects ready
  postgres   95%  coverage · primary target
  mysql      80%  coverage
  sqlite     80%  coverage
  snowflake  70%  coverage · LATERAL FLATTEN, QUALIFY, named args
  bigquery   60%  coverage · window fns landing next
  ansi       --   baseline fallback

rust 1.75+ · mit · github.com/f4rkh4d/drift