You might consider using INSTEAD OF triggers for interaction with views.

您也许可以考虑使用 INSTEAD OF 触发器来与视图交互。

youdao

You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.

现在可以在一个表上定义多个 INSERT、DELETE、UPDATE 和 SELECT 触发器，也可以在一个视图上定义多个 INSTEAD OF 触发器。

youdao

Supports before row triggers, after row and statement triggers, instead of triggers and triggers with SQL PL compound statements.

支持行前触发器、行后和语句触发器、instead of触发器和包含SQL PL复合语句的触发器。

youdao

Instead of targeting thrombin directly, SCH 530348 blocks the receptor that thrombin triggers on platelets.

FORBES: Magazine Article