SsGen is a SQL generator library in Java.
This library provides intuitive methods to create SQL in Java source level and it writes out vendor specific SQL Statement as a String object.
SsGen provides programatical methods to assemble SQL statement. So, SsGen lets you build up SQL statement programatically without manipulating String Object by yourself.
SimpleSqlExpression expr = new SimpleSqlExpression();
expr.select("foo", "bar").from("baz").where("foo.id=1");
expr.groupBy("bar.id").having("bar.id>1").orderBy("foo.id");
QueryWriter writer = new AnsiQueryWriter();
String sql = writer.write(expr);