# 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.

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

## Example usage

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

```text
(7,'Ada')
```

### Several literal rows

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

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

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

Output has no trailing newline.

## Format settings

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

| Setting       | Type     | Default | Meaning                                                                                  |
| ------------- | -------- | ------- | ---------------------------------------------------------------------------------------- |
| `snappy_mode` | `String` | `basic` | Read Snappy client files as basic (Hadoop blocks) or framed (standard streaming format). |