title: Using PRAGMAs as sources in SQLite in getting column names
body: <p>Problem:</p>
  
  <p>I want to do this operation</p>
  
  <p><code>select name from pragma table_info(my_awesome_table)</code></p>
  
  <p>However, it yields a syntax error. I have the sneaking suspicion this is possible, but it doesn't seem to be documented as usable in the <a href="http://www.sqlite.org/lang_select.html" rel="noreferrer">SELECT</a> docs with sqlite.</p>