How to Get Real-Time Notifications for Row Changes in Materialize Database?

What are ways that I could get realtime "notifications" when rows in MD are inserted/updated/deleted? I want to use https://sqlrooms.org/ to build a data app with human/AI collaboration. eg externally I get claude to run some SQL against MD, that changes the state of MD, and then the user's browser needs to be notified so it can update the UI. Ideally this would be with the incremental changes, not just "something changed, you better just re-run "SELECT * FROM huge_table". I found https://duckdb.org/community_extensions/extensions/events, but that isn't available in MD (and possibly also wouldn't even solve my problem, I didn't look into that much). I know in MD dives, there is useSql(). Is that reactive/doing what I want here? Could I use that in my own app, or does that only work since it is hosted on MD infrastructure? Thanks for the help all!