Saw the title, searched the comments for jOOQ. jOOQ needs to be mentioned in this context. With jOOQ you basically write Java-SQL-DSL, and with some code gener

Saw the title, searched the comments for jOOQ. jOOQ needs to be mentioned in this context. With jOOQ you basically write Java-SQL-DSL, and with some code generation from your schema you have really neat type safety (and code completion). String SQL queries are not the answer to ORMs, imho, we need a level in between. jOOQ provides a really cool set of features in that space.