I interpret parent's point as doing the SQL level tuning through the ORM's dedicated mechanisms, and not through a raw string.

Any decent ORM has extra procedures to tweak the resulting query and inject optimizations that it can't arrive at automatically, kicking the ORM away every time there's some tweak to do is counterproductive.