[bobbyi]

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

[michaelcampbell]

For a background action/job use case though, how often would you have to re-materialize the view?