Can't resolve label reference for ORDER BY / GROUP BY. Textual SQL expression 'id desc' should be...

利用flask框架开发网页时，运行程序遇到Can’t resolve label reference for ORDER BY / GROUP BY. Textual SQL expression ‘id desc’ should be explicitly declared as text(‘id desc’)，这是由于MySQL的版本导致的。
报错前的程序如：
result = Login.query.filter_by(name=name).order_by(“id desc”).first()
修改后的程序如：
result = Login.query.filter_by(name=name).order_by(Login.id.desc()).first()

换了一种写法程序就执行OK。