如何在flask-SQLAlchemy中查询SQL视图？

创建 SQL 视图并将其映射到 SQL Alchemy模型中：

from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class MyView(db.Model):
    __tablename__ = 'my_view'
    # 该视图的字段
    field1 = db.Column(db.Integer, primary_key=True)
    field2 = db.Column(db.String(128))
在SQLAlchemy的查询中使用from_statement()方法来查询视图：
my_view_query = db.session.query(MyView).from_statement('SELECT * FROM my_view')
my_view_results = my_view_query.all()
注意，上面的查询语句需要与MyView模型中指定的__tablename__保持一致。
完整示例代码如下：
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:password@localhost/mydatabase'
db = SQLAlchemy(app)
class MyView(db.Model):
    __tablename__ = 'my_view'
    field1 = db.Column(db.Integer, primary_key=True)
    field2 = db.Column(db.String(128))
@app.route('/')
def get_my_view():
    my_view_query = db.session.query(MyView).from_statement('SELECT * FROM my_view')
    my_view_results = my_view_query.all()
    return str(my_view_results)
if __name__ == '__main__':
    app.run()