Fix DBError in execute_update_returning method

[joshyorko]

Address DBError in execute_update_returning method by managing transactions correctly.

• Transaction Management in execute_update_returning:

  • Add a transaction initiation using BEGIN before executing the UPDATE statement.
  • Add a COMMIT statement after executing the SQL statements.
  • Add a ROLLBACK statement to handle errors.

• Transaction Management in _create_run:

  • Add a check using in_transaction() to ensure a transaction is active before calling execute_update_returning.
  • Add a transaction initiation using BEGIN before calling execute_update_returning.
  • Add a COMMIT statement after calling execute_update_returning.
  • Add a ROLLBACK statement to handle errors.