clickhouse-client and clickhouse-local Autodetect Stdin Compression from File

clickhouse-client and clickhouse-local will autodetect compression of stdin when it is redirected from a file. This closes #70865. #73848 (Alexey Milovidov).