Comment by bobbyi

Materialized views handle this scenario, but sqlite doesn't have them