title: Execute dynamic query within another query
body: <p>I have a table that looks like this</p>
  
  <pre><code>sql_stmt                             table
  ---------                            ------
  'select max(date) from table1'       table1
  'select max(date) from table2'       table2
  'select max(date) from table3'       table3
  </code></pre>
  
  <p>How can I query this table so it ends up returning the following result.  Basically I want to execute the statement in the column and return the other columns as is.</p>
  
  <pre><code>max_date               table
  -------                -------
  2014-07-01             table1
  2012-12-31             table2
  2014-01-01             table3
  </code></pre>