Query params for table works but not for column name

[sanggonlee]

Company or project name

No response

Question

I can pass a table name to a query like so

ALTER TABLE {table: Identifier} ...

But it looks like I cannot do that with column names.

Why is that so?

[amabilee]

ALTER TABLE {table: Identifier} would work because many SQL dialects support dynamic table names via identifiers, especially in prepared statements. However, columns are more rigid in how they're interpreted within the SQL engine.

If you need to dynamically change column names, you usually have to construct the SQL string dynamically in your application code, which then gets passed to the SQL engine.

RENAME COLUMN {old_column} TO {new_column};