sql_values ​

Description ​

Comma-separated parenthesized literal rows. Input accepts SQL literals but does not evaluate arbitrary SQL expressions or functions. Output has no trailing newline.

Input and output. Select it with FORMAT sql_values. Names ignore ASCII case; use the snake_case name shown here.

Each row is a parenthesized list of SQL literals; commas separate the rows. There is no INSERT prefix or column-name header.

Input decodes supported literals rather than evaluating expressions or functions. Supply a compatible destination column list and use ordinary INSERT VALUES when expression evaluation is needed. Output has no trailing newline.

SELECT expressions FORMAT sql_values;
INSERT INTO table [(columns)] [SETTINGS ...] FORMAT sql_values
<data>

Example usage ​

SELECT CAST(7 AS Int64) AS id, 'Ada' AS name FORMAT sql_values;

(7,'Ada')

Several literal rows ​

CREATE TABLE people (id UInt32, name String);
INSERT INTO people VALUES (1, 'Ada'), (2, 'Grace');

SELECT id, name FROM people ORDER BY id
FORMAT sql_values;

(1,'Ada'),(2,'Grace')

Output has no trailing newline.

Format settings ​

Use a statement SETTINGS clause; these options are not persisted by SET.