ENH:
This is my first time creating an issue on GitHub.  I did not see one like it but if there is, please reference it.

I see a lot of communications about adding upsert features to the to_sql method. I think this is a great idea.  I would like to know if there is any possibility of adding functionality to call a stored procedure which takes care of the upsert.

Something like:
df.to_sql('mytable', schema='dbo', con=engine, index=False, method='mytable_upsert', stored_proc=True)

I ask because I want to keep my data in a df to upload but I also would like to handle the upsert issues with a stored procedure for performance reasons.

I am using the pymssql driver.

Yes Matthew, I read #14553 and #29636  before creating this.  These are very good efforts and I hope they are adopted.  The difference with my request is that I would like to be able to call a stored procedure in the database which would handle inserting or updating rows inside the database itself which is faster than issuing a command in python to insert and then finding it exists and then issuing an update on the row.  There are ways to do this, just not with a dataframe using to_sql.
