I recently gone through something and found a unique way of aliasing. I thought it must be share so other techies also aware of it (or might be you already aware of it).
See below example
FROM (VALUES ('Rajat',30),
('Virendra',45)) AS T(Name,Runs)
Now when you it you will get following result
I hope you may like this tips.