> I'm not sure if differential dataflow can provide this.

Yes, it can, but you will have to write the views yourself, in Rust.

Materialize (https://materialize.com) exists, though, and compiles SQL to differential-dataflow programs, in order to provide exactly what you're asking for.

(I work for Materialize)