Table.insert() documentation does not make it clear it will commit

[douglas-raillard-arm]

Table.insert() documentation does not state it will commit any on-going transaction. This happens inside insert_chunks() when using the sqlite connection as a context manager.

This turned out to be an issue in my code where I use manual transaction control, where insert() commits the transaction earlier than I expected.

[douglas-raillard-arm]

Also ensure_autocommit_off() will not prevent insert() from committing, which is somewhat unexpected considering insert() commits by default and provides no direct tunable to prevent that.