How to format long SQL queries according to PEP8

Question

According to PEP 8 (Maximum Line Length), a line should never be longer than 79 characters.

When I try to split up queries, however, I run into issues like continuation characters, and invalid tokens, etc.

For example, what would be the best way to format this query, according to PEP8?

cursor.execute("SELECT pivot_id FROM aud_qty WHERE hshake1 is NULL AND ((strftime('%s', DATETIME('now')) - strftime('%s', sent_to_pivot)) / (60)) > 30;")

Answer 1

What about

cursor.execute("""SELECT pivot_id
                    FROM aud_qty
                   WHERE hshake1 is NULL
                     AND ((strftime('%s', DATETIME('now')) -
                         strftime('%s', sent_to_pivot)) / (60)) > 30;
               """)

? Using """ or ''' you get the same behaviour as a very long string but you can use newlines just fine. And your database won't mind them either.

Answer 2

In this way you have a clearly looking SQL statement that complies with PEP8 guidelines.

cursor.execute("""
    SELECT pivot_id
    FROM aud_qty
    WHERE hshake1 is NULL
        AND ((strftime('%s', DATETIME('now')) -
            strftime('%s', sent_to_pivot)) / (60)) > 30;
""")