SQLite 3.8.0 isn't an incredibly feature-rich release but in part due to the NGQP introduction, the version was bumped to 3.8.0 rather than 3.7.18. There's also some chance of legacy applications breaking on this release.
For those curious about the Next Generation Query Planner for SQLite, it's described at length on this web-page and it's "almost always better" than the existing query planner, which comes up with the best algorithm to accomplish an SQL statement. This leads to faster and better query plans with SQLite 3.8.
SQLite 3.8.0 also supports partial indexes and new pragmas for cache_spill, query_only, and defer_foreign_keys. There's also a host of new compile-time options, other enhancements, and bug-fixes to this lightweight SQL library release.
More details on SQLite 3.8.0 can be found via SQLite.org.