What's broken

Table.update(values={...}) raises NotImplementedError: SQL conversion is not implemented for this type when a value is a numpy scalar such as np.int64, np.int32, np.float32, or np.bool_. These arise naturally from indexing an ndarray or a pandas int/bool column. np.float64 happens to work (it subclasses float), which makes the failure inconsistent and surprising.

df = pd.DataFrame({"id": np.array([10, 20], dtype="int32")})
t.update(where="id = 1", values={"id": df["id"].iloc[0]})   # np.int32
# -> NotImplementedError: SQL conversion is not implemented for this type

Why it happens

value_to_sql is a singledispatch with handlers only for native Python types and np.ndarray; numpy integer/floating/bool_ scalars aren't Python subclasses, so they fall through to the NotImplementedError base.

Fix

Register handlers for np.bool_, np.integer, and np.floating that delegate to the existing native handlers.

Test

value_to_sql on np.int32/int64/float32/float64/bool_ all convert; np.int32 raised before.