3 ms·
On top of that you only have to learn SQL once and you can use it pretty much everywhere without having to learn a different ORM - Learn once, write everywhere.
by fragile_frogs 6y ago
On top of that you only have to learn SQL once and you can use it pretty much everywhere without having to learn a different ORM - Learn once, write everywhere.
Another thing that speaks for raw SQL is that it's a lot easier to debug queries, just copy/paste the query into your SQL editor and start figuring out what's wrong, you can't just do that with an ORM.
- tester34 6y ago"debug queries" yea, that's the point where things start getting exciting when you have logic in queries that you actually have to debug. I too love 200 LoC (tiny, in fact) procedures that inside build ""dynamic SQL"" aka string concat and EXEC with many OUTPUT parameters 10/10 experience, would recommend it to everyone. No, I don't want to debug my queries because it means that I'm probably doing too much on the database. I treat database more like a fancy data storage with outdated language, not as a business logic layer.