sqlalchemy类似sql语句的as重命名的方法

userInfo = select user.id as uid, class.id as cid, user.name where user.class=class.id;
类似的sqlalchemy写法，User和Class为两个model
userInfo = self.db.query(User.id.label('uid'),Class.id.label('cid'),User.name).filter(User.class == Class.id).all()