23

I'd like to reformat some SQL statements that are a single string with newlines in to something that's much easier to read.

I don't personally know of a good coding style for indenting SQL - how should nested queries / where clauses / left joins / etc by represented to maximise readability?

Has anyone seen a pretty-printing algorithm that does this already? In Python would be even better.

Helen
  • 87,344
  • 17
  • 243
  • 314
Simon Willison
  • 15,642
  • 5
  • 36
  • 44

0 Answers0