Sorted column moves to the leftmost position in the CSV export

I am running into an issue with the CSV export of a table visualization. When I export a table visualization with no columns sorted, everything seems to work.

But, when I add sorting to one of the columns, that column appears on the left hand side of the export

I want to sort by a column, but have that column remain on the right hand side

How do I accomplish this?

This is the way this currently works. If your tables has columns A,B,C and you sort it by column C, then export as a CSV, the order of the columns in the CSV file will be C, A, B.