On Sep 24, 2007, at 11:15 AM, Berik Visschers wrote:
> The SQL query I'm trying to map is: > SELECT id, begin_date, end_date, > begin_date IS NOT NULL > OR begin_date <= NOW() > AND > end_date IS NULL > OR end_date > NOW() AS active > FROM package WHERE active = 't' > more specifically youre looking for: SELECT id, begin_date, end_date, (begin_date IS NOT NULL OR begin_date <= NOW() AND end_date IS NULL OR end_date > NOW()) AS active FROM package WHERE active = 't' right ? I would think we can just add "label()" support to ClauseList for this. you can open a trac ticket for this and someone will get around to it, or if you want to try a patch (its not hard one). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---