SQLFluff is a mature, actively maintained SQL linter and auto-formatter with production scope far beyond a simple style checker. It exposes both a Click-based CLI and a Python API (lint, fix, parse, list_rules, list_dialects) and supports over 30 SQL dialects, including ANSI, BigQuery, Snowflake, Postgres, T-SQL, Oracle, Databricks, ClickHouse, and DuckDB. The core pipeline discovers files, optionally expands Jinja/dbt/SQLMesh templating, lexes and parses SQL into a segment tree, then applies configurable rule crawlers that emit lint violations and in many cases generate auto-fixes. The implementation is layered: a public API and CLI wrap a core linter, a grammar-combinator parser, a rule framework with fix primitives, a hierarchical config system, and a pluggy-based plugin host. A Rust workspace (sqlfluffrs) provides an optional high-performance lexer/parser and partial Rust-native rule detection, with extensive Python/Rust parity tests to keep behavior aligned.