import pandas as pd
df = pd.DataFrame(
data={
"col1": [1, 2, 3, 4],
"col2": ['a', 'b', 'c', 'd'],
}
)
SELECT
col1 as col1_renamed,
* EXCLUDE (col1)
FROM df
col1_renamedint64
col2object
0
1
a
1
2
b
2
3
c
3
4
d
df
col1_renamedint64
col2object
0
1
a
1
2
b
2
3
c
3
4
d