v.21.10New Features

Allow Positional Arguments with enable_positional_arguments Setting

Allow positional arguments under setting enable_positional_arguments. Closes #2592. #27530 (Kseniia Sumarokova).
Introduces support for positional query arguments controlled by the setting enable_positional_arguments in ClickHouse.

Why it matters

This feature enables users to use positional parameters in queries, improving query flexibility and parameter handling. It simplifies query construction by allowing placeholders to be referenced by their position rather than requiring explicit naming, addressing user demand for more convenient query parameterization.

How to use it

To use positional arguments, enable the feature by setting enable_positional_arguments=1. Once enabled, queries can include positional placeholders which will be bound in order during execution.