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.