更新：
又见SQLAlchemy的使用配方这里
据我所知，开箱即用不支持创建（只读非实例化）视图。但是在SQLAlchemy
0.7中添加此功能非常简单（类似于我在此处给出的示例）。您只需要编写一个编译器扩展即可
CreateView。使用此扩展名，您可以编写（假设这
t是一个带有列的表对象
id）
createview = CreateView('viewname', t.select().where(t.c.id>5))engine.execute(createview)v = Table('viewname', metadata, autoload=True)for r in engine.execute(v.select()): print r这是一个工作示例：
from sqlalchemy import Tablefrom sqlalchemy.ext.compiler import compilesfrom sqlalchemy.sql.expression import Executable, ClauseElementclass CreateView(Executable, ClauseElement): def __init__(self, name, select): self.name = name self.select = select@compiles(CreateView)def visit_create_view(element, compiler, **kw): return "CREATE VIEW %s AS %s" % ( element.name, compiler.process(element.select, literal_binds=True) )# test datafrom sqlalchemy import metaData, Column, Integerfrom sqlalchemy.engine import create_engineengine = create_engine('sqlite://')metadata = metaData(engine)t = Table('t', metadata, Column('id', Integer, primary_key=True), Column('number', Integer))t.create()engine.execute(t.insert().values(id=1, number=3))engine.execute(t.insert().values(id=9, number=-3))# create viewcreateview = CreateView('viewname', t.select().where(t.c.id>5))engine.execute(createview)# reflect view and print resultv = Table('viewname', metadata, autoload=True)for r in engine.execute(v.select()): print r如果需要，您也可以专门学习方言，例如
@compiles(CreateView, 'sqlite')def visit_create_view(element, compiler, **kw): return "CREATE VIEW IF NOT EXISTS %s AS %s" % ( element.name, compiler.process(element.select, literal_binds=True) )
