Queries impacted by UPDATE triggers are not included in listener callouts by UPSERT statements.

[andersio]

Build Environment
SQLDelight version: 1.4.4
OS: iOS
Kotlin version: 1.4.31

Describe the bug
Given these tables and this AFTER UPDATE trigger:

CREATE TABLE Movie (
    id INTEGER PRIMARY KEY NOT NULL, 
    name TEXT NOT NULL, 
    companyId INTEGER NOT NULL REFERENCES Company("id"), 
    rating INTEGER NOT NULL
);

CREATE TABLE Company (
    id INTEGER PRIMARY KEY NOT NULL,
    name TEXT NOT NULL,
    rating_total INTEGER NOT NULL
);

CREATE TRIGGER IF NOT EXISTS aggregate_ratings
AFTER UPDATE ON Movie
BEGIN
  UPDATE Company
  SET rating_total = rating_total + (new.rating - old.rating)
  WHERE Company.id = new.companyId;
END;

and these statements:

upsert:
INSERT INTO Movie (id, name, companyId, rating) VALUES (?, ?, ?, ?)
ON CONFLICT (id)
DO UPDATE SET rating = excluded.rating;

getAllRatings:
SELECT id, rating_total FROM Company;

getAllRatings() is impacted by an AFTER UPDATE trigger, which can be fired by upsert(). But the synthesized implementation of upsert() does not include any listener callout code.

  public override fun upsert(
    id: Long?,
    name: String,
    companyId: Long,
    rating: Long
  ): Unit {
    driver.execute(1180485434, """
    |INSERT INTO Movie (id, name, companyId, rating) VALUES (?, ?, ?, ?)
    |ON CONFLICT (id)
    |DO UPDATE SET rating = excluded.rating
    """.trimMargin(), 4,
      binders = {
      bindLong(1, id)
      bindString(2, name)
      bindLong(3, companyId)
      bindLong(4, rating)
    }
    )
  }

It seems like the compiler only looks through INSERT triggers for queries being impacted by an UPSERT statements, but not walking through the UPDATE triggers too.