Is it possible to update multiple tables through a view?

Question

SQL

From time to time I hear from database "gurus" that in order to make life easier with databases in which there are many tables, you need to create one large view, which itself will scatter everything there according to the plates. Having looked on the Internet on my own, I found out that it is almost impossible to do UPDATE in view anywhere - like MySQL and Postgresql can do something similar, but to link only two tables you need to write a lot of text, and there is no question of linking more than 2 for updating .
1) Do they generally update a heap of tables through a view?
2) If so, do any databases allow you to do this with a minimum of pain?
3) Doesn't performance drop when working with this method?

Answer 1

In advanced DBMS without triggers, you can usually update the first table from the view, and with the help of triggers instead of, you can update as much as you like.