SQL and ORM frameworks are like ASM and higher-level languages :O

Not really.

Yes ORM can make some queries easier but once you need something more elaborate you most likely will need to go to SQL unless you want to write a lot more code.

Sql is pretty good at reducing overhead code, at least for anything complex.

For basic queries or small datasets ORM could work but I have yet to find one that handles complex joins and conditions on very large data sets without being very verbose or slow.

And by large I mean 100 million rows at least or more per table.

@Voxera so much so, I'll write a blanket ORm but I won't include an actual framework for it, you get to a point the damn thing is the bottle neck and end up ripping it out anyway.