[sqlalchemy] Text subquery column names in the results

Hi, Could you shed some light on what I might be doing incorrectly? I have this text() SELECT * query on top of a one-column sub-query and in the result, I am not getting that column name. ``` stmt = text('select "FirstName", from "Customer"') stmt = select('*').select_from(stmt.columns().alias

Re: [sqlalchemy] Cannot insert strings with a length greater than 2000 into columns with a datatype of Text, VARCHAR, or NVARCHAR using MS SQL Server 2017 and 2019

On Wed, Oct 14, 2020, at 5:35 AM, Nicolas Lykke Iversen wrote: > Hi Mike, > > I've now tested inserting strings with more than 2000 characters using Azure > Data Studio (SQL Server GUI) and everything works. > > Furthermore, I've tested pyodbc (DBAPI) directly, and it only fails when > insert

Re: [sqlalchemy] Cannot insert strings with a length greater than 2000 into columns with a datatype of Text, VARCHAR, or NVARCHAR using MS SQL Server 2017 and 2019

Hi Mike, I've now tested inserting strings with more than 2000 characters using Azure Data Studio (SQL Server GUI) and everything works. Furthermore, I've tested pyodbc (DBAPI) directly, and it only fails when inserting such strings using parameterised SQL queries (it succeeds without using pa