title: add a temporary column with a value
body: <p>I have a select statement like this</p>
  
  <pre><code>select field1, field2  
    from table1
  </code></pre>
  
  <p>What I want is to have a newfield with only value "example".</p>
  
  <p><code>newfield</code> does not exist in the table, but when I run this query it kinda makes a virtual column with the values of example field. </p>