add pip compile to Github Workflows

[hlipsig]

To build the release we should follow our own best practices. The Github workflows should use pip tools to compile, create the requirements.txt file, and test from there.

[federicobond]

Closing this as GitHub workflow now matches roughly the same install procedure as local development.