Any sane ORM will allow you to specify what data you want, and only select that. I'd argue that using an ORM as default and handcrafting optimized queries for

Any sane ORM will allow you to specify what data you want, and only select that. I'd argue that using an ORM as default and handcrafting optimized queries for specific edge cases should be the way to go.