Consider making the transaction on insert_rows, update_rows and delete_rows optional
Is your feature request related to a problem? Please describe. If you want to provide your own transaction (say, if you updating multiple tables), having the default transaction prevents it.
Describe the solution you'd like Add a "useTransaction" parameter for each of the methods that defaults to true to retain existing behavior.
Describe alternatives you've considered Writing the queries manually, but then we lose out on the cleaner interface these methods provide.
Additional context That's about it!
I ran into the same issue today since I need to run my own transaction:
ERROR: src/gdsqlite.cpp:351 - --> SQL error: cannot start a transaction within a transaction
Another method that can benefit for this extra config param is create_table.
See https://github.com/2shady4u/godot-sqlite/issues/220