Query db.session

  query_1 = db\
    .Query(UserModel, func.count(FriendModel.friend_id).label('friends'))\
    .select_from(UserModel)\
    .outerjoin(FriendModel, and_(UserModel.id==FriendModel.user_id))\
    .group_by(FriendModel.user_id)
  s_1 = query_1.subquery('s_1')

  query_2 = db\
    .session.query(s_1, FriendModel.status)\
    .select_from(s_1)\
    .join(FriendModel, FriendModel.user_id==s_1.c.id)

  print query_2.all()

Results:

[(1, u'user6', u'[email protected]', u'user6', u'request'), (2, u'user7', u'[email protected]', u'user7', u'request'), (3, u'user4', u'[email protected]', u'user4', u'request'), (4, u'user5', u'[email protected]', u'user5', u'request'), (5, u'user2', u'[email protected]', u'user2', u'request'), (6, u'user3', u'[email protected]', u'user3', u'request'), (7, u'user1', u'[email protected]', u'user1', u'request'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'accepted'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (8, u'admin', u'[email protected]', u'admin', u'accepted'), (8, u'admin', u'[email protected]', u'admin', u'decision'), (9, u'viktor', u'[email protected]', u'viktor', u'confirmed'), (10, u'user8', u'[email protected]', u'user8', u'request'), (11, u'user9', u'[email protected]', u'user9', u'request'), (12, u'user10', u'[email protected]', u'user10', u'request'), (13, u'elena', u'[email protected]', u'elena', u'confirmed'), (14, u'guest', u'[email protected]', u'guest', u'request')]

I want to make working the way:

query_1 = db
.Query(UserModel, func.count(FriendModel.friend_id).label('friends'))
.select_from(UserModel)
.outerjoin(FriendModel, and_(UserModel.id==FriendModel.user_id))
.group_by(FriendModel.user_id)
s_1 = query_1.subquery('s_1')

query_2 = db
.Query(s_1, FriendModel.status)
.select_from(s_1)
.join(FriendModel, FriendModel.user_id==s_1.c.id)

print query_2.paginate(1, 2)

It invokes an error.
AttributeError: Neither 'InstrumentedAttribute' object nor 'Comparator' object associated with FriendModel.status has an attribute '_autoflush'