FromSqlRaw with Owned Types generates complex and inefficient sql

[darkflame0]

Steps to reproduce

    public class Entity
    {
        public int Id { get; set; }
        public string Prop { get; set; }
        public InnerEntity Inner { get; set; }
    }

    [Owned]
    public class InnerEntity
    {
        [Column(name:nameof(InnerProp))]
        public string InnerProp { get; set; }
    }

    public class TestDbContext :DbContext
    {
        public static readonly ILoggerFactory MyLoggerFactory
= LoggerFactory.Create(builder => { builder.AddConsole(); });
        public DbSet<Entity> Entities { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=TestDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False")
                .UseLoggerFactory(MyLoggerFactory);
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            using var db = new TestDbContext();
            db.Database.EnsureCreated();
            db.Entities.FromSqlRaw("select * from Entities").Select(a => a.Inner.InnerProp).ToList();
            db.Entities.Select(a => a.Inner.InnerProp).ToList();
            Console.ReadKey();
        }
    }

SQL

--  db.Entities.FromSqlRaw("select * from Entities").Select(a => a.Inner.InnerProp).ToList();
      SELECT [t].[InnerProp]
      FROM (
          select * from Entities
      ) AS [e]
      LEFT JOIN (
          SELECT [e0].[Id], [e0].[InnerProp]
          FROM [Entities] AS [e0]
          INNER JOIN [Entities] AS [e1] ON [e0].[Id] = [e1].[Id]
          WHERE [e0].[InnerProp] IS NOT NULL
      ) AS [t] ON [e].[Id] = [t].[Id]



--  db.Entities.Select(a => a.Inner.InnerProp).ToList();
      SELECT [e].[InnerProp]
      FROM [Entities] AS [e]

Development Environment

EF Core version: 5.0-rc2
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET CORE 3.1
Operating system: Windows 10
IDE: Visual Studio 2019 16.7.7

[ajcvickers]

@darkflame0 Answered here: #18299 (comment)