I'm not sure if this is possible at all – could the MaterializedPostgreSQL be extended to either support automatically replicating new tables that are added upstream, or support ALTERing it to extend the set of tables?

I'm not using any table filters and right now I have to remove and recreate the whole MaterializedPostgreSQL instance to get the new tables.