title: Use SELECT result as COLUMN name in other SELECT
body: <p>Is it possible to use the result of a select as a string to concatenate with another string in column name in other select?</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT brand 
  FROM articles a 
  WHERE a.id='12345678'
  </code></pre>
  
  <p>Result:  <code>BRAND_A</code></p>
  
  <p>I now want to concatenate <code>_PRICE</code> to <code>BRAND_A</code>...</p>
  
  <pre><code>SELECT (
          SELECT brand
          FROM articles a
          WHERE a.id = '12345678'
          ) + "_PRICE"
  FROM prices p
  WHERE p.id = '12345678'
  </code></pre>
  
  <p>...to actually retrieve:</p>
  
  <pre><code>SELECT BRAND_A_PRICE
  FROM prices p
  WHERE p.id = '12345678'
  </code></pre>