title: How to SELECT * and rename a column?
body: <p>I can easily select all my columns from a table with: </p>
  
  <pre><code>SELECT * FROM foo
  </code></pre>
  
  <p>But if I want to rename the column <code>bar</code> in <code>foobar</code>, I need to specify all the fields manually. This make my query not robust if a new column is added to the table:</p>
  
  <pre><code>SELECT a,b,c,d,bar AS foobar FROM foo
  </code></pre>
  
  <p>Is there a possibility to write something like</p>
  
  <pre><code>SELECT *, bar AS foobar from foo
  </code></pre>