Just use a mature ORM where you can easily combine ORM capabilities and raw SQL, like Hibernate / Spring Data. There you can do raw-raw calls to the SQL driver,

Just use a mature ORM where you can easily combine ORM capabilities and raw SQL, like Hibernate / Spring Data. There you can do raw-raw calls to the SQL driver, map your optimized by hand query to an object or let Hibernate fetch a whole graph of stuff by itself. Use the right tool for the job.