Add support for numpy 2

[aphearin]

In #1083 the dependency chain added a requirement numpy<2. The reason was that none of our CI was running due to some unknown incompatibility with numpy 2. So we kicked the can down the road on support for numpy 2, but this should be restored once numpy 2 incompatibility causes issues with common environments.