sqlfluff-tstring 0.1.0

Auto-format SQL inside Python t-strings using sqlfluff

sqlfluff-tstring

Auto-format SQL inside Python t-strings using sqlfluff.

Finds sql(t"...") calls in .py files and formats the embedded SQL, preserving interpolations and respecting your .sqlfluff config.

Requires Python 3.14+ (PEP 750 t-strings).

Installation

pip install sqlfluff-tstring

Usage

# Format files in-place
sqlfluff-tstring src/

# Check mode (exit 1 if changes needed, for CI)
sqlfluff-tstring --check src/

# Show diff without writing
sqlfluff-tstring --diff src/

# Override SQL dialect
sqlfluff-tstring --dialect postgres src/

# Use a specific .sqlfluff config file
sqlfluff-tstring --config path/to/.sqlfluff src/

What it does

Given a file like:

from sql_tstring import sql

query = sql(t"select   *   from   users   where   id = {uid}   and   name = {name}")

Running sqlfluff-tstring produces:

from sql_tstring import sql

query = sql(t"""
select * from users
where id = {uid} and name = {name}
""")

• Interpolations ({uid}, {name!r}, {val:.2f}) are preserved through formatting
• Single quotes auto-upgrade to triple quotes when sqlfluff introduces newlines
• Multiline content in triple-quoted t-strings is wrapped with leading/trailing newlines
• Supports sql(t"...") and obj.sql(t"...") call patterns
• Respects your .sqlfluff configuration for dialect and rules

CLI options

sqlfluff-tstring [OPTIONS] [PATHS...]

positional arguments:
  paths              Files or directories to format (default: .)

options:
  --check            Exit 1 if changes needed (CI mode)
  --diff             Show diff, don't write changes
  --config PATH      Path to .sqlfluff config file
  --dialect DIALECT  Override SQL dialect
  -v, --verbose      Show unchanged files
  -q, --quiet        Suppress all output

Exit codes: 0 = success/no changes, 1 = changes needed (check mode).

Development

uv sync
uv run pytest
uv run ruff check src/ tests/
uv run ty check src/