Template settings ​

Template settings combine literal text with named or zero-based positional field placeholders. A placeholder states the field escaping grammar.

The row separator appears between rows only. Put a required final newline in the literal row or result template. Input must match literal separators; mismatches are data errors.

Use a statement SETTINGS clause. Defaults in system.settings are read-only; format settings cannot be persisted with SET. Put input settings before FORMAT, because the bytes after the format name are input data.

template_quote_large_integers ​

Type: Bool

Default value: 0

Write integers of at least 64 bits as strings in JSON template fields; retained narrow types stay numeric.

Applies to: template.

template_result ​

Type: String

Default value: ''

Literal result template; empty means ${data}. Output supports data and rows; input may skip prefix or suffix fields.

Applies to: template.

template_row ​

Type: String

Default value: ''

Literal row template with named or zero-based column placeholders and per-field escaping; empty requires an override.

Applies to: template.

template_row_separator ​

Type: String

Default value: \n

Text between template rows, excluding their own literals; never written after the final row.

Applies to: template.