Hey there Yugo,
I've asked a coworker to prepare a self contained example that encapsulates our multiple use cases.
The immediate/eager approach is exactly what we need, as within the same transaction we have statements that can cause one of those "materialized tables" to be updated, and then sometimes have the need to query that "materialized table" in a subsequent statement and need to see the changes reflected.
As soon as my coworker gets that example built up I'll send a followup with it attached.
Thank you,
Adam Brusselback