Creation of a table column and CDT update automatically

Hi All,

Is there a way we can automate the below scenario?

There is a table A with 5 columns and a corresponding CDT. Later there is a need to extend the table and add 2 new columns and update the CDT as well with these new columns.

I am looking for a way wherein an option can be provided to the user itself to add additional data elements based on future business needs and any inputs provided by them will be managed and automatically included in the required UI and input data for the new fields can be saved to the DB. To start with, I am considering a simple scenario and then extend further.

Thanks.

Hitesh