I never had any trouble with Hibernate tbh. It allowed you to drop back to raw sql if needed, and also custom fields to select if needed.

I never understood the fight against ORMs. In the end you'll simply be writing your own framework

Only if you insist on a nearly 1:1 mapping between your data and your class hierarchy.