Thanks.  All the test queries have been passing, but I was just worried as 
this section of code is overly complex and this type of stuff isn't really 
documented (and sort of blends into expectations of the Sql Standard too).

That's what I thought.  I just keep expecting to be able to query using the 
values from `.label()` or `.alias()`.  

ie... the correct form continues

    _unioned = sqlalchemy.sql.expression.alias(unioned, name='unioned')
    _selected = sqlalchemy.select(
            (
                cte_Stream1.c.shared_link_id.label('id'),
                cte_Stream2.c.event_timestamp.label('event_timestamp')
            ),
        )\
        .distinct(cte_Stream1.c.id)\
        .order_by(
            cte_Stream1.c.id.desc(),
            cte_Stream2.c.event_timestamp.desc(),
        )

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to