Gosh, no kidding. (I sorta disagree about ORMs though -- if you're selecting by ID it's monkey work to write those queries, but anything complex, sure, use SQL)
For the edge cases where you need complex joins and/or extra performance, don't try and bother with the ORM, just drop to SQL.
Others should not be allowed in an interactive app anyway: developer should be warned/prevented using a "batch" query by accident.