@beforeUpdate() has not executed the SQL statement

[weretyczx]

Package version

"@adonisjs/core": "^5.8.6",
"@adonisjs/lucid": "^18.1.1",
"mysql2": "^2.3.3",

Node.js and npm version

mariadb:10.5.8-focal
node:v16.14.0
npm:8.13.0

Sample Code (to reproduce the issue)

The scenario is user A has a child user B,
I want to use closure_table to manage the user relationship.

Here is the table SQL statement and the initialized value

CREATE TABLE `user_closures` (
  `ancestor` bigint(20) unsigned NOT NULL,
  `descendant` bigint(20) unsigned NOT NULL,
  `distance` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`descendant`,`ancestor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `user_closures` (`ancestor`, `descendant`, `distance`)
VALUES (1,1,0), (2,2,0);

And now, we need to build the relation with a SQL VALUE (1,2,1)
Here is the insert statement with Adonis Database rawQuery command
I write it in the User model @beforeUpdate()

@beforeUpdate()
public static async updateClosureNode (model: Closure) {
    let parentKey = model.getParentKey()
    if (parentKey) {
      const parent = await model.convert2Model(model.getParentKey())
      parentKey = parent.getKey()
    } else {
      parentKey = 0
    }

    const sql = ` INSERT INTO user_closures (ancestor, descendant, distance)
            SELECT supertbl.ancestor, subtbl.descendant, supertbl.distance+subtbl.distance+1
            FROM (SELECT * FROM user_closures WHERE descendant = 1) as supertbl
            JOIN user_closures as subtbl ON subtbl.ancestor = 2`

    await Database.connection(model.getConnectionName()).rawQuery(sql)
}

protected async convert2Model (parameter): Promise<Closure> {
    let model
    if (parameter instanceof Closure) {
      model = parameter
    } else if (Number.isInteger(parameter)) {
      model = await this.constructor['findOrFail'](parameter)
    } else {
      throw new Error('Closure convert2Model fail')
    }
    return model
  }

And Above code can successfully insert the relation without calling convert2Model await this.constructor['findOrFail'](parameter)
It seems can not call a new model query inside the @beforeUpdate()
Any ideas?