title: How to add a custom column with a default value in an sql query?
body: <p>So I'm doing a basic join query in SQL (postgres)...</p>
  
  <pre><code>SELECT first_name, last_name 
  FROM table1, table2 
  WHERE table1.id = table2.customer_id
  </code></pre>
  
  <p>In the returned result query is it possible to generate an extra column called "default_value" with a string value of "test" in each row returned, and if so how?  I'm not trying to permanently alter the tables with new data, just add an extra column in the result set.  The use case is to store the sql query in a Heroku dataclip so I can generate a csv report.</p>