Lint a SQL file on disk, honoring any .sqlfluff / pyproject.toml config found by walking up from the file's directory.

Args: path: Path to the SQL file to lint. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Fix a SQL file on disk, honoring discovered .sqlfluff config.

Args: path: Path to the SQL file to fix. write: If True, overwrite the file in place with the fixed SQL. If False (default), just return the fixed SQL without touching the file. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Parse a SQL file on disk and return its parse tree, honoring discovered .sqlfluff config.

Args: path: Path to the SQL file to parse. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Lint a raw SQL string using an explicitly specified dialect.

Args: sql: The SQL text to lint. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres". See sqlfluff.list_dialects() for the full set. rules: Optional list of rule codes/names to restrict linting to.

Fix a raw SQL string using an explicitly specified dialect and return the fixed SQL text (does not touch any file).

Args: sql: The SQL text to fix. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres". rules: Optional list of rule codes/names to restrict fixing to.

Parse a raw SQL string using an explicitly specified dialect and return its parse tree.

Args: sql: The SQL text to parse. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres".

List the SQL dialects SQLFluff supports (for use with lint_sql / fix_sql / parse_sql).