The solution is to use SQL views ... s fetched from the database table, can be updated. This means that you don’t have to recreate materialized views each time they’re needed.