title: How can a materialized view be created in sqlite?
body: <p>I've done countless searches on materialized views and SQLite.  Of what I can find there seems to be mentions in 2004 and 2006 that SQLite DOES NOT have materialized views.  Followed immediately by SQLite's changelog from <a href="http://www.sqlite.org/releaselog/3_5_7.html" rel="noreferrer">March 2008</a> where it specifically mentions optimizing materialized views.</p>
  
  <p>Now, I figure logically either the 2004 and 2006 are outdated, or the 2008 changelog is wrong.</p>
  
  <p>Any idea which it is?</p>
  
  <p>If materialized views ARE now in SQLite, how are they created?</p>