[sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Dan
Hello, I have been trying to find the appropriate syntax to query from a user defined function. I am dealing with a SQL Server 2008 database, and I am using sqlalchemy 0.8.4 with pyodbc 3.0.7. The machine the python app is running on is Windows 7 64 bit, but I am using 32 bit python. I

Re: [sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Michael Bayer
On Dec 30, 2013, at 7:12 PM, Dan wpu.cl...@gmail.com wrote: Hello, I have been trying to find the appropriate syntax to query from a user defined function. I am dealing with a SQL Server 2008 database, and I am using sqlalchemy 0.8.4 with pyodbc 3.0.7. The machine the python app is

Re: [sqlalchemy] Querying from MS SQL Server functions

2013-12-30 Thread Dan
Yes, column_literal did the trick. So this is what I have function_call = select([column('table_id'),column('widget_type'),column('effective_date'),column('widget_id')], from_obj=[func.some_user_defined_function('2013-12-01', literal_column(DEFAULT), '1', 1550,