After having written queries to populate whatever platform data structures take the result...to mothership-sized ORMS that keep you as far away from SQL as possible, I have to say a middling ORM like Dapper is optimal for me.

It's lightweight when you want it to be, but if you want to do some heavier/generic use...it can take you quite far.