Funnily, one of my pet peeves is people worrying about the SQL Generated from EF Linq. If you care that much about it I think you should just be writing the SQL by hand.
If the SQL is performant and it returns the expected data, that is good enough for 99.9% of cases.
In this case, with ORMS, even good ones, this happens often enough in production that to actually master the tool you do need to care.