Query: when navigating from dependent to principal to another dependent we can skip the principal table and just compare FKs on the dependent tables in some cases

pointed out by @DJDoena in https://github.com/dotnet/efcore/issues/31350

When we have 1-1 navigation from dependent to principal and then from that principal to another dependent we currently generate 2 joins (D1 INNER JOIN P ON D1.FK = P.PK LEFT JOIN D2 ON P.PK = D2.FK), but instead we could do D1 LEFT JOIN D2 ON D1.FK = D2.FK.