requirements: Adopt pip compile

[tmc]

This includes the work in #193 and builds on it to implement adoption of pip-compile to manage requirements file contents.

Implements #194

[akx]

pip-compile is not a good idea for a repo that is supposed to be used as a library; you can easily end up with transitive dependencies that won't work on all systems.