API for creating new views

[kgodey]

Problem

Users will want to build views from using columns from different tables or views. We need to enable that from the backend.

Proposed solution

We need a way for users to POST a set of columns to /api/v0/views/ and create a new view.

The API should take in one of the following:

• a list of columns (and their associated tables/views)
• an existing table
• an existing view

If an existing table or view is passed in, we'll treat it as a list of all columns from that table or view.

The API should then transform the list of columns into an appropriate query and create a view using that query. To keep the scope small, we'll only support creating views from columns in tables or views that have a direct foreign key relationship to or from one of the other columns specified.

Additional context

• Blocked by API for reading views #467
• Support for deleting a database view #454
• Please spec out this API before implementation and get feedback from @kgodey and @mathemancer.
• This should be closely coordinated with API for suggesting columns relevant to building a view #464
• Mathesar's API Standards

[github-actions]

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

[kgodey]

I'm closing this issue. Backend work will be tracked in these issues once design work has been completed:

• Support for creating a database view from scratch #781
• Support for creating a view based on an existing table or view #782