map_results.py

def map_results(fields, rows):
    keys = [f.split('.')[-1] for f in fields]
    return tuple(dict(zip(keys, row)) for row in rows)

# >>> fields = ('x.id', 'y.name', 'spork')
# >>> rows = [(1, 2, 3), (4, 5, 6)]
# >>> for row in map_results(fields, rows):
# ...    print row
# ...
# {'id': 1, 'name': 2, 'spork': 3}
# {'id': 4, 'name': 5, 'spork': 6}