OwnedType does not work with type configured with .ToSqlQuery

[romfir]

When type configured using ToSqlQuery has an owned type, EF Core generates incorrect query

EF Core Config

async Task Main()
{
	var c = new Context();

	c.Centres.First(); //Invalid object name 'Centres'.
}

public class Context : DbContext
{
	public DbSet<Centre> Centres { get; set; }

	protected override void OnModelCreating(ModelBuilder modelBuilder)
	{
		base.OnModelCreating(modelBuilder);

		modelBuilder.Entity<Centre>(config =>
		{
			config.ToSqlQuery(@"SELECT c.Id, c.Name, cg.Guid FROM CENTRE c
			JOIN CentreGuid cg on cg.CentreId = c.Id
			");

			config.OwnsOne(c => c.Test, c =>
			{
				c.Property(c => c.Guid).HasColumnName("Guid");
			});
		});
	}

	protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
	{
		optionsBuilder
			.UseLazyLoadingProxies()
			.UseSqlServer(".")
			.EnableSensitiveDataLogging(true);
	}
}

public class Centre
{
	public int Id { get; set; }
	public string Name { get; set; }
	public GuidWrapper Test { get; set; }
}

public class GuidWrapper 
{
	public Guid Guid { get; set; }
}

Generated SQL

SELECT TOP(1) [u].[Id], [u].[Name], [c].[Id], [c].[Guid]
FROM (
    SELECT c.Id, c.Name, cg.Guid FROM CENTRE c
    			JOIN CentreGuid cg on cg.CentreId = c.Id
    			
) AS [u]
LEFT JOIN [Centres] AS [c] ON [u].[Id] = [c].[Id]

Here we can observe join to non existant table Centres. The join should eaither not be made and its data shoud be selected from the first part or it should be made to the same subquery as in the first part

Possibly releated issue: #29300

Include provider and version information

EF Core version:
Database provider: Microsoft.EntityFrameworkCore.SqlServer 8.0.4
Target framework: .NET 8.0

[ajcvickers]

Duplicate of #14525