将带有lag函数的查询转换为带有flask的sqlalchemy？

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)

class YourModel(db.Model):
    __tablename__ = 'your_table'
    id = db.Column(db.Integer, primary_key=True)
    # 定义其他列...

    def __repr__(self):
        return '<YourModel %r>' % self.id

from sqlalchemy import func

def your_function():
    result = db.session.query(
        YourModel.id,
        YourModel.column1,
        func.lag(YourModel.column2).over(order_by=YourModel.id).label('lag_column')
    ).all()

    for row in result:
        print(row.id, row.column1, row.lag_column)