Add query translation support for new tuple-returning Join overloads (without a result selector)

See https://github.com/dotnet/runtime/issues/120596 and https://github.com/dotnet/runtime/issues/120587.