def format_sql()

in retrieval_service/datastore/helpers.py [0:0]

• 15 lines of code
• 2 McCabe index (conditional complexity)

def format_sql(sql: str, params: dict):
    """
    Format Postgres SQL to human readable text by replacing placeholders.
    Handles dict-based (:key) formats.
    """
    for key, value in params.items():
        sql = sql.replace(f":{key}", f"{value}")
    # format the SQL
    formatted_sql = (
        sqlparse.format(
            sql,
            reindent=True,
            keyword_case="upper",
            use_space_around_operators=True,
            strip_whitespace=True,
        )
        .replace("\n", "<br/>")
        .replace("  ", '<div class="indent"></div>')
    )
    return formatted_sql.replace("<br/>", "", 1)