ORM is great for what its name stands for — mapping! It is almost impossible to make typo in table names, fields or whatever. But sadly some tricky sql queries (and creation of rel-tables) must be done in raw SQL (ANSI SQL preferably), because it is clear and explicit.
@danilax86 I like how JetBrains IDE:s provide autocomplete for SQL, bringing it closer to ORM. The best thing is automatic migrations... So cool.
We had this discussion, right?