我可以在SQLAlchemy中创建TEMPORARY TABLE而无需附加到Table._prefixes吗？

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

# 创建一个内存中的临时表
metadata = MetaData()
temp_table = Table(
    'temp_table',
    metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    prefixes=['TEMPORARY']
)

# 创建一个持久化表
persistent_table = Table(
    'persistent_table',
    metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String)
)

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

# 创建表
metadata.create_all(engine)

# 插入数据
with engine.begin() as conn:
    conn.execute(temp_table.insert(), [{'id': 1, 'name': 'John'}])
    conn.execute(persistent_table.insert(), [{'id': 1, 'name': 'John'}])

# 查询数据
with engine.begin() as conn:
    result = conn.execute(select([temp_table]))
    print("Temporary table data:")
    for row in result:
        print(row)

    result = conn.execute(select([persistent_table]))
    print("Persistent table data:")
    for row in result:
        print(row)