v.20.10New Feature

Added RawBLOB Format for Unescaped Single Value Input/Output

Added format RawBLOB. It is intended for input or output a single value without any escaping and delimiters. This closes #15349. #15364 (alexey-milovidov).
Added a new data format RawBLOB for inputting or outputting a single value without any escaping or delimiters.

Why it matters

The RawBLOB format addresses the need to handle raw binary large objects directly, enabling users to transfer single values in their exact binary form without any additional formatting, escaping, or delimiters. This simplifies processing and improves compatibility when working with raw binary data.

How to use it

Use the RawBLOB format by specifying it in input or output operations where raw binary data transfer is required, for example, in INSERT or SELECT statements with the format clause:

SELECT * FROM table FORMAT RawBLOB;

or

INSERT INTO table FORMAT RawBLOB
<binary_data>