APIs for data model changes

[kgodey]

Problem

Users may want to alter their data model after they've created tables and have some data. We should allow them to do so.

Proposed solution

DB functions for most of this work have already been implemented. We need to expose them via APIs.

We need APIs for:

1. Moving columns from table A to an existing table B with a foreign key in A
2. Moving columns from table A to a new table C
3. Merging existing tables A and B

The API for moving columns between existing tables should take options for how to handle data that cannot be easily mapped from table A to table B due to multiple values existing for the same foreign key ID. Options are:

• Use only one of the values
• Automatically create an intermediate value.

Please write a technical spec for this on the wiki's Architecture section before starting work on this issue. Get feedback from @kgodey and @mathemancer.

Additional context

• The design issue, Design for data modeling #222, explains this functionality in a lot of detail. Please consult it.
• Our API standards may be useful when creating the technical spec.

[github-actions]

This issue has not been updated in 90 days and is being marked as stale.

[kgodey]

I'm going to close this, we'll create more detailed tickets once we have a design for this.