Ability to observe for entity framework support, similar to the mongodb support we have #1524
Description
We want to be able to similar to the extension methods we have in MongoDB to do .observe() on a DbSet. We need to support all the databases we have today (SQLite, PostreSQL and MsSql). For SQLite we can probably live with an inmemory solution and use interceptors registered in the base dbcontext.
The goal should be that it sets up a subscription to be notified when there are changes. For single entities, if possible, it's great if we get notified by the database with the entity. For queries it's probably easier to just rerun the query.
Important to also support the cross cutting paging, same as we do for MongoDB