[sqlalchemy] Engine.execute interpreting all parameters as string data

I'm new to SQLAlchemy (and Python in general) and have been struggling to get a basic execution wrapper working - the goal is to use of raw batches of parameterized SQL - no ORM. The engine initializes and I can run queries through it without a problem, however the generated SQL from the execute

[sqlalchemy] Re: Engine.execute interpreting all parameters as string data

'... On Jun 8, 10:25 am, Michael Bayer mike...@zzzcomputing.com wrote: Malherbe wrote: I'm new to SQLAlchemy (and Python in general) and have been struggling to get a basic execution wrapper working - the goal is to use of raw batches of parameterized SQL - no ORM. The engine initializes and I

[sqlalchemy] Re: Engine.execute interpreting all parameters as string data

A little testing confirms that the problem is bubbling up from below SA. The equivalent statement run through pyodbc yields the same error. Out of curiosity, I checked to see if Python types were converted as expected in a different context. for pytype in (1, 1.1, decimal.Decimal('1.1'), '1',