You can use SQL to rename a column in your data, but you can also use the Rename Transform.
First, click the +Add Transform button, then select Rename Column. In the working area at the top right, you'll pick the column you want to change, then enter the new column name. When you're finished, press the Run button.
You can repeat this process for each column you want to rename.