Most good ORM's let you write your own SQL to fetch things when you realize there's a particular operation that requires it. So write the initial system with a

Most good ORM's let you write your own SQL to fetch things when you realize there's a particular operation that requires it. So write the initial system with an ORM and then optimize as needs be. That might be obvious from the start, or might become evident later.