I personally like the approach of JOOQ[1] you are basically writing SQL statements using Java and you still can make complex queries and at the time you get ben

I personally like the approach of JOOQ[1] you are basically writing SQL statements using Java and you still can make complex queries and at the time you get benefits of type checking offered by IDE (for example your IDE will actually catch that you're trying to compare column that is an integer with a string). [1] http://www.jooq.org/ http://www.jooq.org/