title: Give an alias in a join statement without changing the select statement (*) in codeigniter
body: <p>I'm working with queries in espressionengine, and I'm coding them with the codeigniter syntax. Here's my query:</p>
  
  <pre><code>$sql = ee()-&gt;db-&gt;select('*');
  $sql = ee()-&gt;db-&gt;from('sometable');
  $sql = ee()-&gt;db-&gt;where('id', $hidden_id);
  $sql = ee()-&gt;db-&gt;get();
  </code></pre>
  
  <p>I'd like to add a join in order to get another value like that:</p>
  
  <pre><code> $sql = ee()-&gt;db-&gt;join('another_table', 'sometable.another_table_id, another_table.id);
  </code></pre>
  
  <p>Now the problem is that in the join statement I add another column with the same name (id).</p>
  
  <p>Instead of changing the select statement (*) I'd like to add an alias in the join statement something like:</p>
  
  <pre><code> $sql = ee()-&gt;db-&gt;join('another_table', 'sometable.another_table_id, another_table.id as another_table_id);
  </code></pre>
  
  <p>Is it doable?</p>