docs: def commit(self, sql=None):
          """Commit the current transaction."""
          self._transaction = False
          try:
              commit = self._con.commit
          except AttributeError:
              return self._con.query(sql or 'commit')
          else:
              if sql:
                  return commit(sql=sql)
              else:
                  return commit()