[benpacker]

You can do this with Materialize or Feldera. The keyword to look for is “incremental view maintenance”