If I understand correctly and this is similar to Postgres' functionality, this is really awesome for any calculated value (particularly anything expensive) that you frequently need to search on.

It makes inserts and updates more expensive, because the calculated values must be recalculated, but it can be an awesome win.

Hooray SQLite!