[client-v2, jdbc-v2] Client should detect server compression and use proper decompression algorithm

[chernser]

Description

There is a change in upcoming ClickHouse version ClickHouse/ClickHouse#108786
which switches to ZSTD(3) for disk and network.

In case of HTTP this is compression requested by compress query parameter (decompress is sent by client to indicate that payload is compressed).

What should be done

• ZSTD compression library is added or existing used
• when client reads payload it should detect magic number of ZSTD and LZ4 sent by server
• if http compression and compress=1 is enabled it should be possible to read payload from server