fix(sql): mock transaction control commands: begin, commit, rollback

Summary

• fix(sql): mock transaction control commands: begin, commit, rollback

Now works with psycopg2 libraryexample_psycopg2.py

---

• Close sbroad#747 (closed)
• Cherry-pick to: none
• Docs follow-up: docs#415 (closed)
• Changelog is updated