title: SELECT value depending on underlying table name
body: <p>I want to set the value of a column based on the table being queried.</p>
  
  <p>Example:</p>
  
  <p>Let's assume two tables: <code>Transportation</code> and <code>Locations</code>. And a <code>SELECT</code> statement with a column named <code>type</code> which shall hold 'Transportation' or 'Locations' based on the table being queried. Is there a way to do this? Maybe something similar to a "RegEx lookahead"?</p>