Enable integration tests on CI/CD

[nadiamoe]

After the latest efforts of migrating integration tests to testcontainers (#340 #341 #342), we may be in a state where integration tests are fast enough to be run on CI/CD, possibly together with unit tests.

We should study how long these tests take to run in GitHub runners, and if we consider that acceptable, enable the tests in the relevant workflows.