SqlStreamInput/Output use TransportVersion from a read-in Version constant. We need to remove the useage of `transportVersion` field
x-pack/plugin/sql/src/test/java/org/elasticsearch/xpack/sql/common/io/SqlStreamTests.java
public void testWriteAndRead() throws IOException {
        BytesRef payload = new BytesRef(randomByteArrayOfLength(randomIntBetween(10, 1000)));
        SqlStreamOutput out = SqlStreamOutput.create(Version.CURRENT, randomZone());
        out.writeBytesRef(payload);
        out.close();
        String encoded = out.streamAsString();
        SqlStreamInput in = SqlStreamInput.fromString(encoded, new NamedWriteableRegistry(List.of()), Version.CURRENT);
        BytesRef read = in.readBytesRef();
        assertArrayEquals(payload.bytes, read.bytes);
    }
    public void testPayloadIsCompressed() throws IOException {
        SqlStreamOutput out = SqlStreamOutput.create(Version.CURRENT, randomZone());
        byte[] payload = new byte[1000];
        Arrays.fill(payload, (byte) 0);
        out.write(payload);
        out.close();