It seems the answer to your question is no, however one hack you can use is to assign a dummy column to separate each new table. This works especially well if you’re looping through a result set for a list of columns in a scripting language such as Python or PHP.
SELECT '' as table1_dummy, table1.*, '' as table2_dummy, table2.*, '' as table3_dummy, table3.* FROM table1 JOIN table2 ON table2.table1id = table1.id JOIN table3 ON table3.table1id = table1.id
I realize this doesn’t answer your question exactly, but if you’re a coder this is a great way to separate tables with duplicate column names. Hope this helps somebody.