title: Python Database API Cursor.Description wont include Table name
body: <p>The Database API docs are here <a href="http://www.python.org/dev/peps/pep-0249/#description" rel="nofollow">http://www.python.org/dev/peps/pep-0249/#description</a></p>
  
  <p>If I use <a href="http://mysql-python.sourceforge.net/MySQLdb.html" rel="nofollow">MySQLdb</a> to do a Table Join in python, then there may be problems, </p>
  
  <pre><code>def query_db(query, args=(), one=False):
      cur = db.cursor()
      cur.execute(query, args)
      rv = [dict((cur.description[idx][0], value)
                 for idx, value in enumerate(row)) for row in cur.fetchall()]
      return (rv[0] if rv else None) if one else rv
  
  result = query_db ('select table1.name, table2.name from table1 inner join table2 on table1.id = table2.id', one=True )
  print result       
  #{'name':'blah blah'}
  </code></pre>
  
  <p>The finale result will be a dictionary with only one key <code>name</code>, that is because <code>cur.description</code> has no information about table name, only table colum name, so the table2.name overwrites the table1.name.</p>
  
  <p>Is this a bug?</p>