cant use col names in trigger subqueries

[Pavan-Nambi]

seed: 10798804968462485620
similar to #4028

turso> CREATE TABLE t (
    a INTEGER,
    b TEXT
);

CREATE TABLE t1 (
    x INTEGER,
    y TEXT
);

CREATE TRIGGER trg
AFTER UPDATE ON t1
BEGIN
    INSERT INTO t
    SELECT * FROM t
    WHERE t.a = 42;
END;

INSERT INTO t1 VALUES (0, '');

UPDATE t1 SET y = 'z' WHERE TRUE;

  x Parse error: no such column: t.a

sqlite3

sqlite> CREATE TABLE t (
    a INTEGER,
    b TEXT
);

CREATE TABLE t1 (
    x INTEGER,
    y TEXT
);

CREATE TRIGGER trg
AFTER UPDATE ON t1
BEGIN
    INSERT INTO t
    SELECT * FROM t
    WHERE t.a = 42;
END;

INSERT INTO t1 VALUES (0, '');

UPDATE t1 SET y = 'z' WHERE TRUE;
sqlite>