Skip to main content

Supported Input

The current MVP targets Python triple-quoted strings.

Supported​

query = """
SELECT *
FROM users
"""
load_users_sql = '''
SELECT *
FROM users
'''

Detected variable names include:

  • sql
  • query
  • *_sql
  • *_query

py-sql-cleaner also detects SQL-like strings based on keywords such as:

  • SELECT
  • WITH
  • INSERT
  • REPLACE
  • UPDATE
  • DELETE
  • TRUNCATE
  • COPY
  • UNLOAD
  • QUALIFY
  • CREATE
  • MERGE
  • VACUUM
  • ANALYZE
  • GRANT

Redshift command-style statements such as COPY and UNLOAD should be run with -d redshift. They are detected and preserved rather than reformatted.

Not Targeted in the MVP​

query = "SELECT * FROM users"

f-strings, Jinja-like templates, and runtime placeholders are detected but skipped by format and extract:

query = f"""
SELECT *
FROM users
WHERE user_id = {user_id}
"""
query = """
SELECT *
FROM users
WHERE ds = '{{ ds }}'
"""
query = """
SELECT *
FROM users
WHERE user_id = :user_id
"""
query = """
SELECT *
FROM users
WHERE user_id = %s
"""

Single-line strings, deep Airflow parsing, full f-string handling, full Jinja handling, and safe parameterized SQL rewriting are outside the current MVP scope.