How to: Export CSV with multiple same header name

Hello guys.

I need help to export csv file with some headers of the same same, for example:

ID,AMOUNT,DESC,AMOUNT,AMOUNT

I know it doesn’t look clever but that’s beyond my control since it’s the format required the app we need to export the data to.

In my original db, I have the AMOUNT1,AMOUNT2 and then I used alias to rename them to AMOUNT but the CSV only export single AMOUNT column.

How do I go about this? Thanks in advance for any insight.