Adding Support for INSERT INTO [db.]table WATCH Query

Why it matters

This feature allows users to perform an INSERT INTO operation combined with a WATCH clause, enabling real-time monitoring or streaming of the inserted data. It helps users observe data as it is being inserted, improving data pipelines, debugging, and live data inspection workflows.

How to use it

Users can apply this feature by appending the WATCH keyword to the INSERT INTO [db.]table query, for example:

INSERT INTO my_table WATCH

This will trigger the query to insert data and simultaneously watch the inserted stream.