sqlalchemy.exc.CompileError: Can't resolve label reference for ORDER BY / GROUP BY.

问题：sqlalchemy.exc.CompileError: Can't resolve label reference for ORDER BY / GROUP BY. Textual SQL expression 'status desc' should be explicitly declared as text('status desc')

解决：新版本sqlalchemy不能直接使用order_by("status desc")了，需要使用User.status.desc()

方法：

users = self.db.query(User).order_by(User.status.desc()).all()

对于func方法需要先定义变量，如下

user_num = func.count(User.id).label('num')
users = self.db.query(User.age, user_num).filter(User.classes == 12).order_by(
    user_num.desc()).all()

参考：ttps://www.e-learn.cn/content/wangluowenzhang/448355