SqlStreamInput/Output use TransportVersion from a read-in Version constant. We need to remove the useage of `transportVersion` field
x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/common/io/SqlStreamOutput.java
private final ByteArrayOutputStream bytes;
    public static SqlStreamOutput create(Version version, ZoneId zoneId) throws IOException {
        ByteArrayOutputStream bytes = new ByteArrayOutputStream();
        StreamOutput uncompressedOut = new OutputStreamStreamOutput(Base64.getEncoder().wrap(bytes));
        Version.writeVersion(version, uncompressedOut);
        OutputStream out = CompressorFactory.COMPRESSOR.threadLocalOutputStream(uncompressedOut);
        return new SqlStreamOutput(bytes, out, version.transportVersion, zoneId);
    }
    private SqlStreamOutput(ByteArrayOutputStream bytes, OutputStream out, TransportVersion version, ZoneId zoneId) throws IOException {
        super(out);
        this.bytes = bytes;
        super.setTransportVersion(version);
        this.writeZoneId(zoneId);
    }
    /**
     * Should be called _after_ closing the stream - there are no guarantees otherwise.
     */
    public String streamAsString() throws IOException {
        return bytes.toString(StandardCharsets.ISO_8859_1);
    }
}