Do not use SELECT *. Not only are you probably pulling far more data than you need (which may or may not matter, depending on how big that data is) but as you've noticed, duplicate field names are problematic — and make your code fragile (what happens when the DBA adds another column?).
Instead, select exactly the columns you need, and under the names you want: