The ideal case is that the DB can work out the difference in the subscribed query caused by the DB update so that the front end can make changes incrementally a

The ideal case is that the DB can work out the difference in the subscribed query caused by the DB update so that the front end can make changes incrementally and doesn't have to rerender the entire list/table.