I'm not talking about trivial applications. PK lookups are easy no matter what you use. I'm talking about non-trivial applications. > > And they're always la

I'm not talking about trivial applications. PK lookups are easy no matter what you use. I'm talking about non-trivial applications. > > And they're always lazy, so you never really know when the N+1s are going to happen. > There are tools to detect this. Please use them regardless. Even if you're writing queries but hand, enough functions on the stack can hide an N+1 I don't want to have to use a tool to "detect" anything. I want my queries to return exactly what they're expected to return, or my code will fail. No surprises.