Unlike Python, strings in C++ have to use double quotes, single quotes are only used for single characters (a different data type). So it should be:
PYBIND11_MODULE("sigmoid", m) {
m.def("d_sigmoid", &d_sigmoid, "sigmoid");
}