Elgin,

>Do I need to manually build an SQL statement using an Array built with AFIELDS() and concatenation? Or is there a better way?

Pretty much so, you'll have to replace the * in the select with an enumerated list of all the other columns in order to prevent the duplicated/renamed columns.