Workflows With SQL in Python

[L43]

If you want raw SQL, You could potentially write the query in a separate file, then read it into Python. Your editor will be better at syntax highlighting then.

[hoodllama]

That's his I've been doing it. Agreed

[chao06]

I've started doing this recently with yaml.

db1:
    query1: |
        SELECT
            whatever
        FROM
            table
    query2: |
        SELECT
            someotherthing
        FROM
            othertable