title: Does SQLite support common table expressions?
body: <p>Does SQLite support common table expressions?</p>
  
  <p>I'd like to run query like that:</p>
  
  <pre><code>with temp (ID, Path) 
  as (
    select ID, Path from Messages
  ) select * from temp
  </code></pre>