Is it possible to rename tables columns in the view without altering the backend column headers?

[ghost]

For example, Select [column1] AND [column2] AS [combinedcolumn] [column1] AS [1]