>Actually, FirstVal() and LastVal() aggregate functions would give us the best of both worlds - they'd be fairly simple to implement, therefore fast, and would count as aggregate functions. Now if we only had a way to influence the standard :).

A result of a query should only depends on data it runs again. IOW, it should not depend on how SQL Engine process the query. The FirstVal() and LastVal() aggregate functions will breake it.