How does it know which rows would be affected how when we have something complex? Even better: Is there a detailed proposal or a paper to allow me to gawk at the intelligence of other people? :)
https://jon.thesquareplanet.com/papers/phd-thesis.pdf
This is the paper on which Readyset and Noria are based.
I've mirrored the file here, this link should work for you: https://tazj.in/blobs/noria-thesis.pdf