Yes, you can do this. I do not think it is documented (though I may be wrong). Nor do I think it is standard SQL (though standard SQL is a rapidly moving target). It works the same as the order by clause except, of course, that the referenced projection expression must not contain an aggregate (you will get an error message if you do that).