API for suggesting columns relevant to building a view

[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 an API that takes 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 return a full list of columns that could potentially added to a view containing the list of columns specified. To keep the scope small, we'll only suggest columns from tables or views have a foreign key relationship to or from the list of columns specified.

Additional context

• Blocked by API for reading views #467
• Please spec out this API before implementation and get feedback from @kgodey and @mathemancer.
• Support for deleting a database view #454
• The output of this will be used in API for creating new views #465
• 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 this issue once design work has been completed:

• Support for creating a database view from scratch #781