Does CONCAT AS in SQL make a new column in the queried table or just assign a name to the output result

Answer 1

Just assigns a name to the output result...

...unless you're using it to create or alter tables.