[matwood]

I have found that ORMs get you up and running more quickly, but that time saved is eventually given back working through ORM performance issues. As someone who has written complex SQL for many years, it is simply faster and easier to just write optimized queries up front. Something like jOOq makes this nice with typing and some minimal object mapping.

[67726e]

That's ultimately true of any framework, but ORMs are a beast all their own. Having a light abstraction framework on top of SQL, that ultimately respects it, makes a huge difference at the end of the day. No magic, just results. I've watched coworkers spend days tracking down obscure performance issues related to mapping in Hibernate that just wouldn't occur when using something like jOOQ. The only overhead I get is possibly having some DTOs to map into via a simple interface. Hardly more effort than one would expend configuring Hibernate mappings what with its myriad options.