v.21.12New Features

Add Support for Identifier Table and Database Query Parameters

Add support for Identifier table and database query parameters. Closes #27226. #28668 (Nikolay Degterinsky).
Add support for Identifier table and database query parameters in ClickHouse.

Why it matters

This feature introduces the ability to use Identifier parameters for table and database names in queries. It solves the problem of safely parameterizing identifiers, enhancing query flexibility and security by allowing dynamic table and database names without risking SQL injection or syntax errors.

How to use it

Users can utilize Identifier parameters when composing queries to dynamically specify table or database names. This allows injecting identifiers as query parameters, for example using client interfaces or prepared statements that support this new parameter type.