Create Aliases In Bulk?
<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>