OK r4566 of trunk also allows text() within select_from(), so you can use textual bind params (denoted by a colon ':'):
generate_series = text("generate_series(:x, :y, :z) as s(a)") s = select([(func.current_date() + literal_column("s.a")).label("dates")]).select_from(generate_series) # load up some parameters: s = s.params(x=5, y=6, z=7) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---