Agree, my datasets have multiple billions of rows and if I don’t know the details of the query, or have the ability to tune it, it’s utterly insufficient for my needs.
I still fail to see how anybody who actually knows sql and works with “Big Kid” datasets would use an ORM.