Feature Request: Implement Progress Tracking for Long-Running Queries

### Description:

I would like to suggest the implementation of a progress tracking mechanism for long-running queries, such as `insert from S3`. This feature could be incredibly beneficial in monitoring the execution of these extensive operations.

### Motivation:
In many cases, queries in ClickHouse can take a substantial amount of time to execute, ranging from several minutes to hours or even days. During such long-running operations, users currently do not have a way to monitor the progress of these queries. Implementing a progress tracking feature, akin to what the ClickHouse CLI client offers, would be extremely beneficial. This would not only improve the user experience by providing real-time updates on query execution but also help in diagnosing and troubleshooting any issues that might arise during the execution of these lengthy queries.

No files, tests, or entry points are named. Start by surveying the Python driver's query execution path and how ClickHouse exposes progress for long-running operations; done would require a defined progress-tracking mechanism with real-time updates for operations such as insert from S3.

Written by the indexing model from the issue text.