title: Select AS temp_name FROM table WHERE temp_name = something?
body: <p>You know how you can assign a temporary column name to a return value in a SQL statement like this?</p>
  
  <pre><code>SELECT something+this+that AS myvalue FROM mytable
  </code></pre>
  
  <p>Is it possible to use the temporary name <code>myvalue</code> as a conditional?</p>
  
  <pre><code>SELECT something+this+that AS myvalue FROM mytable WHERE myvalue = 10
  </code></pre>
  
  <p>I can't seem to figure out the syntax to do this. The only way I can figure out how to do it is to rewrite out the entire column definition again like this:</p>
  
  <pre><code>SELECT something+this+that AS myvalue FROM mytable WHERE something+this+that = 10
  </code></pre>
  
  <p>Obviously the above example is a trivial example. My query I need to do this on is extremely complexed, so having the rewrite each returned column definition for each conditional will be quite a hassle.</p>
  
  <p>So anyways, what is the syntax for this? Is it possible?</p>