title: Create Aliases In Bulk?
body: <p>I'm trying to join three tables, <code>products</code>, <code>taxes</code> &amp; <code>categories</code>. All these tables have conflicting column names. I'm aware that we get around this conflict by creating aliases. </p>
  
  <pre><code>products:
      id
      name
      ...
  
  taxes
      id
      name
      ...
  
  categories
      id
      name
      ...
  </code></pre>
  
  <p>My question is, is there a convenient way to create aliases in bulk? What I mean is something like</p>
  
  <pre><code>SELECT products.* as product.*, taxes.* as tax.*, categories.* as category.*
  ...
  </code></pre>
  
  <p>I would expect the result set to have columns like:</p>
  
  <pre><code>product.id, product.name, tax.id, tax.name, ...
  </code></pre>
  
  <p>Or, do I have to stick with something tedious as:</p>
  
  <pre><code>SELECT products.id as product_id, products.name as product_name,
         taxes.id as tax_id, taxes.name as tax_name, ...
  </code></pre>