turso> CREATE TABLE t1 (id INT);
CREATE TABLE t (id INT);
turso> CREATE TRIGGER my_trigger AFTER INSERT ON t
BEGIN
    INSERT INTO t1 VALUES (NEW.id);
END;
turso> ALTER TABLE t1 RENAME TO t1_new;
turso> select * from sqlite_schema;
┌─────────┬────────────┬──────────┬──────────┬───────────────────────────────────────────────────────────────────────────────────────┐
│ type    │ name       │ tbl_name │ rootpage │ sql                                                                                   │
├─────────┼────────────┼──────────┼──────────┼───────────────────────────────────────────────────────────────────────────────────────┤
│ table   │ t1_new     │ t1_new   │        2 │ CREATE TABLE t1_new (id INT)                                                          │
├─────────┼────────────┼──────────┼──────────┼───────────────────────────────────────────────────────────────────────────────────────┤
│ table   │ t          │ t        │        3 │ CREATE TABLE t (id INT)                                                               │
├─────────┼────────────┼──────────┼──────────┼───────────────────────────────────────────────────────────────────────────────────────┤
│ trigger │ my_trigger │ t        │        0 │ CREATE TRIGGER my_trigger AFTER INSERT ON t BEGIN INSERT INTO t1 VALUES (NEW.id); END │
└─────────┴────────────┴──────────┴──────────┴───────────────────────────────────────────────────────────────────────────────────────┘
turso> INSERT INTO t VALUES (1);
  x Parse error: no such table: t1

turso>

turso on  sim [$] is 📦 v0.4.0-pre.3 via 🐍 v3.12.3 via 🦀 v1.88.0 took 53s
❯ sqlite3
SQLite version 3.50.4 2025-07-30 19:33:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE t1 (id INT);
CREATE TABLE t (id INT);
sqlite> CREATE TRIGGER my_trigger AFTER INSERT ON t
BEGIN
    INSERT INTO t1 VALUES (NEW.id);
END;
sqlite> ALTER TABLE t1 RENAME TO t1_new;
sqlite> select * from sqlite_schema;
table|t1_new|t1_new|2|CREATE TABLE "t1_new" (id INT)
table|t|t|3|CREATE TABLE t (id INT)
trigger|my_trigger|t|0|CREATE TRIGGER my_trigger AFTER INSERT ON t
BEGIN
    INSERT INTO "t1_new" VALUES (NEW.id);
END
sqlite>