Bind member on result of single entity result subquery

[smitpatel]

    [ConditionalTheory]
    [MemberData(nameof(IsAsyncData))]
    public virtual Task Update_Where_Join_set_property_from_joined_table(bool async)
    => AssertUpdate(
        async,
        ss => from c in ss.Set<Customer>().Where(c => c.CustomerID.StartsWith("F"))
              select new { c, LastOrder = c.Orders.OrderByDescending(o => o.OrderDate).FirstOrDefault() },
        e => e.c,
        s => s.SetProperty(c => c.c.City, c => c.LastOrder.OrderDate.ToString()),
        rowsAffectedCount: 35,
        (b, a) => Assert.All(a, c => Assert.NotNull(c.City)));

We fail to translate c.LastOrder.OrderDate because we don't correctly process the ShapedQueryExpression from c.LastOrder to recognize it as entity reference in SqlTranslator.

Could affect #28524