Review app available at: https://hge-ci-pull-339.herokuapp.com

Review app available at: https://hge-ci-pull-339.herokuapp.com

upserts should not be allowed on views.

Review app available at: https://hge-ci-pull-339.herokuapp.com

Review app available at: https://hge-ci-pull-339.herokuapp.com

@rakeshkky What is blocking this PR?

@shahidhk This PR requires few console changes. Console has to allow creating insert/update/delete permissions based on data from information_schema.views table.
@praveenweb ^

Review app available at: https://hge-ci-pull-339.herokuapp.com

@rakeshkky Please resolve server conflicts here too.

Review app available at: https://hge-ci-pull-339.herokuapp.com

Review app available at: https://hge-ci-pull-339.herokuapp.com

Review app available at: https://hge-ci-pull-339.herokuapp.com

All committers have signed the CLA.

Test steps:

1. Test the editable view flow

• Create a table author with id and name
• Create the following view to test editable view:

CREATE OR REPLACE VIEW sample."author_article" AS 
 SELECT a.name,
    a.id
   FROM author a
  ORDER BY a.id;

• Track the view
• Navigate to the view > permission and you should see insert/update/delete columns activated.
• Add permission and test in GraphiQL

2. Test the non-editable view flow

• Create article table with id, author_id and description
• Create the following view to test non-editable view:

CREATE OR REPLACE VIEW public."author_article" AS 
 SELECT a.name,
    a.id, ar.description
   FROM author a
   JOIN article ar
   ON a.id = ar.author_id
  ORDER BY a.id;

• Track the view
• Navigate to the view > permission and you shouldn't see insert/update/delete columns.

Test can be performed across the schemas.

@rakeshkky Please update in case I have missed any use case.

Review app available at: https://hge-ci-pull-339.herokuapp.com

@karthikvt26 Let's add a note in the permissions UI to indicate why configuration for insert/update/delete is not available as shown below. Also, if it's not too much of a change, show the columns for insert/update/delete like you would for a regular table but disable the options in them.

Review app available at: https://hge-ci-pull-339.herokuapp.com

@karthikvt26 @dsandip - can we enable Insert tab (next to Browse rows) for views that allows mutations?

Review app https://hge-ci-pull-339.herokuapp.com is deleted