Execute many
For SQLAlchemy’s included dialects, support or equivalent support is currently as follows:
SQLite - supported for SQLite versions 3.35 and above
PostgreSQL - all supported Postgresql versions (9 and above)
SQL Server - all supported SQL Server versions [1]
MariaDB - supported for MariaDB versions 10.5 and above
MySQL - no support, no RETURNING feature is present
Oracle - supports RETURNING with executemany using native cx_Oracle / OracleDB APIs, for all supported Oracle versions 9 and above, using multi-row OUT parameters. This is not the same implementation as "executemanyvalues", however has the same usage patterns and equivalent performance benefits.
https://docs.sqlalchemy.org/en/20/core/connections.html#engine-insertmanyvalues