jOOQ is the best way to write SQL in Java
Type safe SQL builder with code generation and automatic query result data mapping
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird