If the code is handwritten or not does not really matter when you are looking at the generated execution plans and so on for troubleshooting. I worked with sev

If the code is handwritten or not does not really matter when you are looking at the generated execution plans and so on for troubleshooting. I worked with several systems not using ORMs that still have the N+1 problem. And if a schema generator also is used it won't forget to add indexes. My main issue with ORMs is that schema changes over time becomes more and more scary. Another thing is that many libs comes with a bit of magic. A seemingly innocent change can move things from SQL to the client or the other way around. Ending up with large performance impacts. EDIT: And probably 100% of all the security related issues I have fixed in SQL would have been avoided with an ORM framework.