By default in Athena (probably more generally Presto/Trino) SELECT * lowercases columns names.

I’ve found a workaround by explicitly specifying the columns names in the proper case SELECT SomeColumn, SomeOtherColumn, YetAnotherColumn.

But UNLOAD is itself lowercasing again, hence the final Parquet has lowercase columns names.

Is there a way to preserve the original casing or specify the columns names manually like with SELECT?