Also, too much tedious work outside of python is required for each upload. Writing dataframes to excel and using SSIS packages launched by subprocess.run() and the dtexec utility Works well, but ...

pySQLY is a Python ... Database connection manager │ ├── sqlite.py # SQLite connector │ ├── mariadb.py # MariaDB connector │ ├── postgres.py # PostgreSQL connector │ ├── oracle.py # Oracle connector │ ...