sql_format: Format (pretty-print) SQL

In polyglotSQL: SQL Parsing, Analysis and Dialect Translation

Format (pretty-print) SQL

Description

Parses and re-renders SQL as canonically indented statements. Complexity guards protect against pathological inputs; exceeding a guard raises a polyglot_guard_error.

Usage

sql_format(
  sql,
  dialect = "generic",
  max_input_bytes = NULL,
  max_tokens = NULL,
  max_ast_nodes = NULL,
  max_set_op_chain = NULL
)

Arguments

sql	A single character string with one or more SQL statements (separated by ⁠;⁠).
dialect	Dialect used for parsing and rendering.
max_input_bytes, max_tokens, max_ast_nodes, max_set_op_chain	Complexity guard limits. NULL (default) uses the upstream defaults (16 MiB input, 1e6 tokens, 1e6 AST nodes, 256 chained set operations); Inf disables a guard; a positive number sets an explicit limit.

Value

A character vector with one formatted statement per input statement.

Examples

cat(sql_format("select a,b from t where x=1 and y=2"))

polyglotSQL documentation built on Sept. 27, 2026, 5:06 p.m.