Alter table supports adding column as primary key

[killme2008]

What type of enhancement is this?

API improvement

What does the enhancement do?

The label or tag in TSDB protocol will be added to the primary key in GreptimeDB.
I think we can provide a dialect SQL to add primary column:

Combines:

alter table test add column new_tag STRING;
alter table test drop primary key;
alter table test add primary key (old_tag1, old_tag2, ..., new_tag);

Into:

alter table test add primary key column new_tag STRING;

Implementation challenges

No response