Custom Columns: does the colum get added to the original table?

Answer 1

No the column gets added for display and extract purposes only and does not change the original table remeber you are only manipulating data in this case not altering tables

Answer 2

no coz ur using select query where the resultant will store in result set table which is temporary one