[Hawxy]

Modern EF Core can generate SQL very close to handwritten and will aggressively warn you if you do something dumb. I wouldn't worry about it.

[magicalhippo]

Good to know, though we have mostly either trivial (ie by indexed key) or complex queries, with very few "medium complexity" queries.

For the complex ones we like to have full control as it almost always turns into a major ops issue if the queries are not performing well.

Though perhaps if we can catch changes of the generated queries in our test suite we could let EF generate them. Trust but verify kinda deal.

[ThinkBeat]

My example was 9 months old. At least in this instance EF did not warn, and caused great problems.