http://www.perlmonks.org?node_id=430748


in reply to Re^2: DBI, mysql, SELECT with JOIN and field names
in thread DBI, mysql, SELECT with JOIN and field names

from DBIx documentation:

NOTE: Because the query result is returned in a hash, there can only be one out of multiple fields with the same name fetched at once. If you specify multiple fields with same name, only one is returned from a query. Which one this actually is, depends on the DBD driver.

so i don't think there is a more lazy perlish way yet... Are you going to provide it? :-)