Re: [sqlalchemy] UPSERT method for MS SQL Server

2021-09-22 Thread Mike Bayer
it is something that would ideally be available for the MS SQL and Oracle dialects. We've gotten by implementing specific "upsert" constructs for SQLite, Postgresql and MySQL that are not "MERGE". The thing is MERGE is SQL standard, although I'm not sure it's worth it to make "MERGE" a

[sqlalchemy] UPSERT method for MS SQL Server

2021-09-22 Thread De Vos Meaker
Hi, I have recently had to make a custom UPSERT method with Microsoft SQL, using their suggested MERGE method here: https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15 Is it within the scope of the SQLAlchemy project to create an extension for