Is there any java library to format SQL?

I am looking for a simple library [free] wherein i can use something like this:-

String formattedSQL = xyzLib.format开发者_Python百科 ( sql );

Is there any such library? Or is there a way to format the SQL?

---

I'm not aware of a library that does this, but you might look at Hibernate's SQL formatter. From my experience it does a pretty good job at prettifying SQL statements, but as always, it might not be exactly what you want.

---

Yohei Yamana (vertical-blank) has written an open source, pure-Java standalone, zero-dependencies SQL Formatter. It is available from maven central:

<dependency>
  <groupId>com.github.vertical-blank</groupId>
  <artifactId>sql-formatter</artifactId>
  <version>1.0</version>
</dependency>