The pros and cons of updatable views in PostgreSQL

I recently started looking at a class of bug reports in which non-admin users of Hasura were unable to use certain newer features from Postgres. For example, if the schema contains a table with a GENERATED AS IDENTITY column (a more modern, SQL-compliant equivalent of a SERIAL typed column), then admins would be able to insert data into the table, but non-admin users would not. A similar issue…

This is an excerpt. The full article continues at Hasura.