@rocketraman why is hibernate considered a "heavy-weight" ORM? From experience trying many different ORMs, Hibernate is the most complete ORM solution out there with the widest support for different databases.
You also get to write in native SQL if you really need to, HQL (which is my preferred way of doing it) or do it the JOOQ way.