I’ve been working with efcore lately and it has so far almost always produced what I’d expect, at least for my arbitrarily complex joins and left joins, both join calls and Include calls (and include simplifies a ridiculous amount of cases)

They also removed the intermixing between server logic and db logic, which greatly reduces nonsense occurring