Test all adapters in integration

[damien-carcel]

Currently, "real world" adapters (like SQL repo and queries) are tested in integration, while "in memory" implementations are only unit-tested.
We could instead test them in integration using the "acceptance" environment.

In the process, rename the environments to be closer to this new setup:

• acceptance → memory
• integration & end-to-end → test (get back to the original Symfony env name, so recipes updates will be easier in the future)