upvote
It is implemented here as DuckDB extension: https://github.com/ila/openivm/
reply
Have you run into scenarios where a simple view doesn't accomplish what you require? I always feel like views do everything I want - because the speed is so great, the full recompute isn't that big a deal.

Maybe it's a bigger deal when you have multiple users/and or more repeated queries against something that's really expensive?

reply
I've had some use cases with low latency requirements and frequent data updates. If you want to serve data on a frontend fast it's often not feasible to recompute everything every time
reply