title: duplicate column names in query
body: <p>I don't think it's possible but I thought I would ask anyways.</p>
  
  <p>I have a MySql 5.+ query as such...</p>
  
  <pre><code>SELECT p.*, u.* FROM princess p JOIN unicorn u ON p.id = u.princess_id
  </code></pre>
  
  <p>It's kind enough to return me all of the princesses and unicorns ;).  The problem is that the returned result set may contain duplicate column names (not good).  If both tables have a column named <code>name</code> how can I differentiate it without explicitly coding the alias like <code>p.name as 'princess_name'</code> and <code>u.name as 'unicorn_name'</code>?  </p>
  
  <p>Also, I can't use the column index so if there isn't a better way I'll just hand code all the aliases myself.</p>