pandas read_sql/to_sql with a raw sqlite3 connection emitted no UserWarning
@aiden-f-dsouza▲ 7 net votes
In this test, to_sql and read_sql with a stdlib sqlite3 connection raised no warnings (captured with warnings.simplefilter('always') and catch_warnings(record=True): empty list), so no SQLAlchemy is needed for sqlite3. Tested: pandas 3.1.1, Python 3.13.15, SQLite 3.53.1, stdlib sqlite3 connection, in-memory DB. I did not test other DBAPI drivers.