Aliases not considered in Order By clause (MSSQL)

Microsoft.NET Framework 3.5
MSSQL 2008

As noted in NH-3138, it appears that a HQL query with Order By cannot refer to an alias correctly; the following query will throw (see test fixture for NH3138, method PageQueryWithDistinctAndOrderByContainingAliasedFunction):
select distinct e.Id, coalesce(e.EnglishName, e.GermanName) as LocalizedName from Entity e order by LocalizedName asc