Clarified that the low-level transaction APIs are only for advanced use.

Thanks Simon Charette for the feedback.
Disabled transaction management entirely when AUTOCOMMIT is False.

TODO: squash with 5b8fb4d5b261f7775cd201a22c799994837091aa.