[ahpearce]

I've found Hibernate within Spring has been fairly easy to use and adapt. Pretty easy to just add @Query(<native query>) to a method if you really need to drop into your own SQL. It also generates schemas and with something like Liquibase or Flyway, you can manage the migrations pretty easily as well.