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).Why it matters
This feature introduces the ability to useIdentifier 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 utilizeIdentifier 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.