Is there a performance difference using AS keyword in SQL?
I wouldn't expect much if any noticeable overhead as all that is doing is aliasing the name of the column in the result set.

The question I would ask however, is why it's being done in the first place? All I can think of is to prevent the code which uses the query breaking if a column is renamed (as long as the alias isn't changed).