Improve error detection in the middle of stream

[mshustov]

see https://github.com/ClickHouse/ClickHouse/issues/75175 and previous discussion https://github.com/ClickHouse/clickhouse-connect/issues/122#issuecomment-1427077665

[genzgd]

To clarify, I think that error detection with standard/streaming queries using Native format is working correctly. The issues identified in https://github.com/ClickHouse/ClickHouse/issues/75175 would only affect queries using the raw_query client method, so the scope is relatively limited.