> Namely, you can’t write a query whose result updates every time the underlying data change
Yeah, you can. With triggers. Or just a plain old view.