This is what I've been doing:

%sql
replace table table_name as
select
old_column_name as new_column_name
from table_name

(make sure to list all columns in the same sequence)