How to Override a column in table.*
Specify only the columns you want to see.

select (column1+column2) AS column1,
       column3,
       column4,
       column5
from table1


It is bad form to use table1.*, as your SQL code will be vulnerable to changes in the table structure.  It is a good habit to always specify the exact columns you want.