Formatted SQL

[Felix B]

Do you know of any good SQL formatting library or would you even consider to (optionally) ouput formatted SQL?

Example:

unformatted:

select groups0_.PhoneBookEntry_id as PhoneBoo1_0_0_, groups0_.groups_id as groups_i2_1_0_, phonebookg1_.id as id1_3_1_, phonebookg1_.version as version2_3_1_, phonebookg1_.name as name3_3_1_ from PhoneBookEntry_PhoneBookGroup groups0_ inner join PhoneBookGroup phonebookg1_ on groups0_.groups_id=phonebookg1_.id where groups0_.PhoneBookEntry_id=7

formatted:

SELECT

groups0_.PhoneBookEntry_id AS PhoneBoo1_0_0_,

groups0_.groups_id         AS groups_i2_1_0_,

phonebookg1_.id            AS id1_3_1_,

phonebookg1_.version       AS version2_3_1_,

phonebookg1_.name          AS name3_3_1_

FROM PhoneBookEntry_PhoneBookGroup groups0_ INNER JOIN PhoneBookGroup phonebookg1_

ON groups0_.groups_id = phonebookg1_.id

WHERE groups0_.PhoneBookEntry_id = 7;

[Quinton McCombs]

I have never looked for any formatting libraries.  I am not at all opposed to outputting formatted sql.  There have been a few requests for such functionality.