Any ORM worth it's salt has an escape hatch that allows you to do all those fancy raw SQL queries.
But the amount of queries that aren't fancy, and that an ORM is perfectly capable of abstracting away is (imho) 90% of all queries run.
Why make 90% or queries more tedious and error prone, just to make 10% slightly easier?