def METHOD_NAME(self, vals: dict):
    """
    Inserts the values contained in the ``vals`` dictionary into the
    underlying table. The keys of ``vals`` are used as the column names.
    """
    with self._connection() as c:
        with self._cursor(c) as cur:
            # vals is a dictionary, its keys are the column names and its
            # values are the values to insert
            sql = "INSERT into %s (%s) VALUES (%s)" % (
                self._db_table,
                ",".join(vals.keys()),
                ",".join(["{}"] * len(vals)),
            )
            sql, vals = prepare_sql(
                sql, self._db_drv.paramstyle, list(vals.values())
            )
            logger.debug(
                "Executing SQL with parameters: %s / %r", sql, vals
            )
            cur.execute(sql, vals)
            c.commit()