How to run AFTER INSERT TRIGGER after related objects are inserted.

[pijablonski]

Setup: Hasura 2.0.9 on PostgreSQL 13.3.

Using example from Hasura Docs to model my task:

Let’s say an author has an array relationship called articles to the articles table and some other similar array relationships to different tables.
I am inserting an author object along with its related objects through relationships.

{
  name: "John",
  articles: {
    data: [
      {
      title: "GraphQL Guide",
      content: "Let's see what we can do with GraphQL"
      },
      {
      title: "Authentication Guide",
      content: "Let's look at best practices for authentication"
      }
    ],
  },
  books: {
    data: [ (...) ]
  }
  // some other array relationships
}

Now, what I want to do, is to run single do_something_for_new_author_function(INSERTED_OBJECT), but I want to do it after all relationship objects are inserted.

From Hasura docs:

1. The parent object is inserted first. i.e. in this case, the author is inserted. The id of the author is collected in this step.
2. The array relationship objects are inserted at the end.

So I cannot just define an AFTER INSERT TRIGGER on author, as it would run between steps 1 and 2.

On the other hand, do_something_for_new_author_function should run within the same transaction as insert mutation(s).

So... How do I acheive this?

Just in case it matters - I am using insert_one type of mutation for now.