[eric_the_read]

I'll have to see if I can adapt this to my somewhat idiosyncratic syntax:

  SELECT field, other_field
    FROM table
   WHERE some_thing IN (
         SELECT id 
           FROM other_table
         )
     AND other_field IS NOT NULL

(mostly it's right-aligning keywords, but there are a few other weird tweaks)

[zeroimpl]

I tried your SQL in the demo, and it came out like this:

    SELECT
        field,
        other_field
    FROM
        TABLE
    WHERE
        some_thing IN (
            SELECT
                id
            FROM
                other_table)
            AND other_field IS NOT NULL

I'd have expected the last line to have one less indentation level...

[FelipeCortez]

sql-indent for Emacs supports that: https://github.com/alex-hhh/emacs-sql-indent

[mjibson]

sqlfmt gets pretty close to this: https://sqlfum.pt/?n=30&indent=4&spaces=1&simplify=1&align=2...

[ComputerGuru]

I’ve adopted the same format myself, it reminds me of aligning numbers at the decimal point.

[overcast]

I do similar, keeps both keywords and fields vertically aligned.

[jerrysievert]

I do too, but it breaks down on me for some specific:

* ORDER BY

* INNER JOIN

etc