News for hackers. Stuff that matters.
Re:What ORMs have taught me: just learn SQL (2014) by setr on Saturday September 21, 2019 @12:33AM (#21033542)
The ordering is always a problem, because your logic may not follow it. Eg if your set of conditions apply to multiple queries, then you might know your where conditions before you know your select/from clauses.

So instead of building up your sql string in a straightforward fashion, you need to have at minimum an abstraction that delays construction.

You get lead into vietnam as almost a direct result of SQL’s context-sensitive clauses.

Re:What ORMs have taught me: just learn SQL (2014) by spion on Saturday September 21, 2019 @02:46AM (#21033900)
Or you could go with LINQ's approach from (x) where (y) select (z).

Honestly, I think LINQ and entity framework successfully solved most ORM concerns