As someone who always prefers native SQL over ORM queries, I'll add a couple of counterpoints. Most IDEs provide intellisense/validation of ORM entities, vs tr

As someone who always prefers native SQL over ORM queries, I'll add a couple of counterpoints. Most IDEs provide intellisense/validation of ORM entities, vs treating SQL like a raw string. ORM entities also make refactoring and impact analysis slightly easier. Despite those benefits, I generally find ORMs a pain for anything besides the most basic queries.