Is there any java library to format SQL?

Question

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

String formattedSQL = xyzLib.format ( sql );

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

Answer 1

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.

Answer 2

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>