Repeated statement in the ORDER BY clause instead of referring to the alias in the SELECT

[kresimirlesic]

EF core repeats the SQL statement in the order by section instead of referring to the alias.

This can cause duplicate branches (possibly complex) in the execution plan which can easily be avoided using aliases.

Example:

db.Users.Select(x => new { OrderProperty = (complex subquery).Count() }).OrderBy(x => x.OrderProperty)

would be translated to something along:

select (complex sql) from Users
order by (complex sql)

[maumar]

dupe of #18775