Multi-line SQL statement formatting in Python using black formatter

Question

When formatting, black ends up concatenating multiline SQL statements:

Before formatting:

df = pd.read_sql(
"SELECT TOP 1000 * " \
"FROM [ETZ3BSC1].[NT0001\BD9524].[AA_Trades]", conn
)

After formatting:

df = pd.read_sql(
    "SELECT TOP 1000 * " "FROM [ETZ3BSC1].[NT0001\BD9524].[AA_Trades]", conn
)

Is it possible to enable multi-line SQL statement support? Adding # fmt: off and # fmt: on before and after the code works but I'm interested in multi-line SQL code support, not disabling the formatter completely.

Tim Biegeleisen · Accepted Answer · 2019-11-19 08:25:13Z

2

Python's multiline string syntax should work here:

df = pd.read_sql("""
    SELECT TOP 1000 *
    FROM [ETZ3BSC1].[NT0001\BD9524].[AA_Trades]""", conn
)

answered Nov 19, 2019 at 8:25

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Petras Purlys Over a year ago

It does but this ends up highlighting way too much background characters in PyCharm for example (all the way to the end of the screen).

Collectives™ on Stack Overflow

Multi-line SQL statement formatting in Python using black formatter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related