Allow Parameters in Partition Queries for ALTER TABLE Command

Why it matters

This feature enables parameterization in queries that involve partitions, improving query flexibility and scripting capabilities by allowing dynamic partition specification. It solves the limitation where partitions had to be specified explicitly, facilitating automation and safer query construction.

How to use it

When writing queries that modify partitions, such as ALTER TABLE ... DROP PARTITION, you can now use query parameters to specify partitions dynamically. For example, use prepared statements or parameter placeholders for the partition identifier.