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


in reply to DBI, mysql, SELECT with JOIN and field names

Not a direct solution to your problem, but you could do this:

SELECT ..., requests.name AS request_name, ..., requestors.name AS requestor_name, ...