[FEATURE]: Live Queries for other dialects

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

It feels like every big project eventually reaches a point where it needs to stay in sync with the database in some cases.

Instead of relying on sockets, it would be great to have something like Live Query (which is only availble for [Expo SQLite](https://orm.drizzle.team/docs/latest-releases/drizzle-orm-v0311)) to be available for other dialects as well.

Is this achievable, and can we expect it in the future?