I often find myself knowing how to write a query in SQL but spending sometimes hours figuring out how to write it in a specific ORM, even worse is I'm probably not going to know what the ORM code does in 6 months time.

SQL seems far more portable.