Usage: /opt/iamguarded/clickhouse/bin/clickhouse-format [options] < query Allowed options: --query arg query to format -h [ --help ] produce help message --comments keep comments in the output --hilite add syntax highlight with ANSI terminal escape sequences --oneline format in single line --max_line_length arg (=0) format in single line queries with length less than specified -q [ --quiet ] just check syntax, no output on success -n [ --multiquery ] allow multiple queries in the same file --obfuscate obfuscate instead of formatting --backslash add a backslash at the end of each line of the formatted query --allow_settings_after_format_in_insert Allow SETTINGS after FORMAT, but note, that this is not always safe --seed arg seed (arbitrary string) that determines the result of obfuscation --format_alter_operations_with_parentheses arg (=1) If set to `true`, then alter operations will be surrounded by parentheses in formatted queries. This makes the parsing of formatted alter queries less ambiguous. --max_parser_depth arg Limits maximum recursion depth in the recursive descent parser. Allows controlling the stack size. Possible values: - Positive integer. - 0 — Recursion depth is unlimited. --max_query_size arg The maximum number of bytes of a query string parsed by the SQL parser. Data in the VALUES clause of INSERT queries is processed by a separate stream parser (that consumes O(1) RAM) and not affected by this restriction. :::note `max_query_size` cannot be set within an SQL query (e.g., `SELECT now() SETTINGS max_query_size=10000`) because ClickHouse needs to allocate a buffer to parse the query, and this buffer size is determined by the `max_query_size` setting, which must be configured before the query is executed. :::