Closed
Description
Location of the documentation
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_sql.html
Documentation problem
Documentation says that con is to be a "sqlalchemy.engine.Engine or ..." while source says that con can be a "SQLAlchemy connectable(engine/connection) or ..."
Suggested fix for documentation
Documentation should mention that a SQLAlchemy Connection is acceptable because some operations like an upsert via a temporary table in SQL Server need to ensure that the same DBAPI connection is used for the entire operation. (SQL Server local temp tables are only visible to the connection/session that created them).