e.g. for db2

CREATE TABLE MaterializedTable as (

    SELECT  mydata
    FROM    mytable
    WHERE   mycolumn = 123

)
data initially deferred refresh deferred
GO

Syntax exists for Oracle as well. Worth testing that out alongside DATABASE LINK

And support custom modify sqls after:

refresh table .

CALL ADMIN_CMD('RUNSTATS ON TABLE . WITH DISTRIBUTION AND DETAILED INDEXES ALL')