I have two questions: 1. I'm using postgresql, and I sometimes need to do column type conversions. In postgresql, this is normally done with the ::FOO operator where FOO is a data *type*. Somtimes, but not usually, these data types are also available in function-like factories, but in this case that doesn't help me. SHould I use the cast(some_column, 'int') expression here?
2. Frequently, I have a list of things upon which to operate. This list of things is not in a table, and I may want to call a function on this list of things. If I were writing the sql directly, I'd do something like this: select function_foo(BAR.x) FROM (select value1, value2, value3) BAR(x); What's the best way to emulate this with sqlalchemy? -- Jon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.