如何在SQLAlchemy中插入t1(SELECT*FROM t2)？

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData, select, insert

# 创建一个引擎
engine = create_engine('sqlite:///example.db')

# 创建一个元数据对象
metadata = MetaData()

# 定义表1和表2
t1 = Table('t1', metadata,
           Column('id', Integer, primary_key=True),
           Column('name', String))

t2 = Table('t2', metadata,
           Column('id', Integer, primary_key=True),
           Column('name', String))

# 创建表
metadata.create_all(engine)

# 插入数据到表2
with engine.begin() as conn:
    conn.execute(t2.insert(), [{'id': 1, 'name': 'John'}, {'id': 2, 'name': 'Jane'}])

# 从表2中选择数据并插入到表1
with engine.begin() as conn:
    stmt = insert(t1).from_select(('id', 'name'), select([t2.c.id, t2.c.name]))
    conn.execute(stmt)