Graphql-engine: Allow creation of SQL View right from UI (not via SQL script)

[revskill10]

SQL View is nesessary in Hasura for powerful queries.
We need a way to declaratively create sql views through UI, like we do with SQL Tables.
Some features:

• Allow choosing aggregation functions from chosen list.
• Allow specify joining multiple tables with aliasing fields from those tables.

This feature requires huge amount of frontend work, but it's a powerful feature to have.

[maxpain]

+1

[jasonmccallister]

Was just looking to make this request but found this issue! It would be great for those of us that are less SQL inclined.

Also, it would be really useful to "preview" this view (showing the results in the UI) before committing the view.

Additionally, it might be helpful to expose creating a view when using the query functionality in the data tab? So users can use the data tab to select their "view" and then click a button to automatically create the review.

[rikinsk-zz]

We should facilitate generating views for standard tasks like

• exposing subset of columns
• data aggregations
• joining tables
• using group_by