Something like this:
subscribe ('SELECT * FROM tableA', callback)
On the initial subscription, 'callback' would be called once for each row in 'tableA', then again when a row is inserted or updated. It would be the same as Firebase in this respect.