What I want to do: Select all columns but apply a function to one of the selected columns in a shorthand manner such that I don't have to type out all of the column names
Current approach: I am currently using
select table.* to select all columns in a table.
Name data1 data2 data3 .... a 1 1 1 b 1 1 1 c 1 1 1
SELECT * from table
Desired outcome: I want to be able to select all columns then apply a function to a specific column, is it possible to do this with
select * or does it require selecting all column names and applying a function to my specified column?