from personal experience this was a much larger problem during .net framework days. Now with EFcore, most generated queries are much more sane and performant