If I understand correctly and this is similar to Postgres&#x27; functionality, this is really awesome for any calculated value (particularly anything expensive) that you frequently need to search on.<p>It makes inserts and updates more expensive, because the calculated values must be recalculated, but it can be an awesome win.<p>Hooray SQLite!