3 ms·

IDEA if you want to use it for other things (or any other JetBrains IDE). Nothing comes close feature-wise. If you don't: - https://www.depesz.com/2022/09/21/

• jillyboel 2y ago
  i think the idea sql prettifier is pretty silly sometimes. it really likes indenting stuff to make sure things are aligned, which often results in dozens of whitespaces
  • homebrewer 2y ago
    It makes it easy to distinguish null vs not null columns and other similar things, so I personally don't mind.
    • jillyboel 2y ago
      It's more about queries like (dummy example) RETURN CASE WHEN a = 1 THEN 1 ELSE 2 END; where it insists on aligning WHEN past CASE. I think it would be perfectly reasonable to indent WHEN and ELSE 4 spaces less, for example. Similar things happen with nested conditions like (a or (b and c)) all getting pushed to the right