feat: specify package build and runtime dependencies

[oxidase]

Use case: psycopg package requires libpq library installed and running targets potentially work if libpq is installed in the system root FS and not hermetic. Sandboxed test targets fail with message

.../psycopg/psycopg/pq/__init__.py", line 106, in import_from_libpq
    raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found

The suggested workaround in bazelbuild/rules_python#1348 to use psycopg2-binary is not recommended as mentioned in https://www.psycopg.org/docs/install.html#psycopg-vs-psycopg-binary