Like a lot of programmers, I'm very... meticulous... when it comes to writing code. I detest looking at malformed code, and will reformat it -- if not refactor completely -- at the first opportunity. But, like a lot of geeks, I'm lazy efficient, so I use a class of utilities called beautifiers to help maintain my code (well, other's code, but let's not get snarky).

I've used HTML Tidy to clean up gnarly web pages...

I've used Jalopy to clean up mangled Java code...

I've even used a relatively ancient Visual Basic 3.0 one back in the day. The name escapes me, but it was in 1995 and I remember I paid $100 bucks for it. Given the nature of the code I was working with, it was worth it.

After googling awhile, I stumbled across a yacc version and a couple of on-line versions here and here. The former on-line one has some Delphi source available for download -- too bad I haven't used Delphi for years.

So, why is it so difficult to find an open source SQL beautifier similar to Jalopy or HTML Tidy?

When I get an opportunity, I'll have to knock one out.