Far easier to write correct sql than to convince the orm how to form correct sql.
Far easier to write correct sql than to convince the orm how to form correct sql.
For smaller systems it might be ok I guess, but stay alive long enough and you 'll see that sooner or later every small system desires to grow, grow and grow!
good ORMs all have a way to fine-control the underlying statements to avoid querying individual rows one by one.
I'm fairly proficient with sql queries and i still don't like writing sql queries and binding to objects manually
No, that makes no sense.
If you have to investigate 2 places where performance issues have cropped up and hand-write the SQL in those places, while 95% of your application works just fine, how did you lose all the benefits?
My SQL competency was fine from the beginning, thank you very much.