-3

I am looking for a database solution that supports column append out of the box. Ideally, it should work like pandas library where new column can be added very easily in one command. Row values in the new column are all different. Also, column data types are in general different from each other. Any idea which database would be best suited for this?

closed as unclear what you're asking by hot2use, mustaccio, LowlyDBA, Michael Green, Paul White Feb 11 at 23:18

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 4
    Welcome to DBA.SE. Could you give an example from start to end? Where would the columns be added/appended: At the end or at the beginning? What do you mean with Row values in the new column are all different? Are the values added as soon as a column is added? Where from? I think you are looking for two things: RDBMS that allows you to add columns (basically all of them allow that) and a program logic (Better suited for Stack Overflow). Please add as much details as possible to your question. – hot2use Feb 11 at 10:19
  • 2
    database solution that supports column append out of the box ALTER TABLE ADD COLUMN is supported in all RDBMS "out of the box", it seems. – Akina Feb 11 at 12:44
  • 1
    I would ask which ones don't support it. – Joe W Feb 11 at 18:55