Order by inspection sometimes returns wrong expression for labeled expressions

The following simplified code illustrates the problem.
import sqlalchemy as sa
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.ext.hybrid import hybrid_property


engine = sa.create_engine('sqlite:///:memory:')
Base = declarative_base()
Session = sessionmaker(bind=engine)
session = Session()


class User(Base):
    __tablename__ = 'user'
    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.String)


class Organization(Base):
    __tablename__ = 'organization'
    id = sa.Column(sa.Integer, primary_key=True)
    name = sa.Column(sa.String)


class OrganizationMember(Base):
    __tablename__ = 'organization_member'
    user_id = sa.Column(sa.Integer, sa.ForeignKey('user.id'), primary_key=True)
    organization_id = sa.Column(
        sa.Integer,
        sa.ForeignKey('organization.id'),
        primary_key=True
    )
    is_admin = True
    user = sa.orm.relationship(User, backref='memberships')
    organization = sa.orm.relationship(Organization)

    @hybrid_property
    def id(self):
        return '{0}:{1}'.format(self.organization_id, self.user_id)

    @id.expression
    def id(cls):
        return sa.func.concat(
            cls.organization_id,
            sa.text("':'"),
            cls.user_id
        ).label('id')


sa.orm.configure_mappers()

print(
    session.query(User.id)
    .join(User.memberships)
    .order_by(OrganizationMember.id)
)

# SELECT user.id AS user_id
# FROM user JOIN organization_member ON user.id = organization_member.user_id
# ORDER BY id

print(session.query(User.id).order_by(User.name.label('id')))

# SELECT user.id AS user_id FROM user ORDER BY id
Comments (6)
