[#91781] CI: Run tests for alembic migrations

[#91781] server: tests: Add tests for alembic migrations

[#91781] server: Add pytest-alembic dependency

[#91781] server: alembic: Fix broken SQLite migration

[#91781] server: database: Fix alembic not applying in CI

[#93274] server: pubsub-demo: Bump Kafka to 4.0.1

[#93274] server: pubsub-demo: Minor bug and typo fixes

[#86113] CI: test-pubsub-acl-side-effects: Anchor common_only

[#86113] deploy: pubsub-demo: README: typos

[#86113] CI: Add test-pubsub-acl-side-effects

[#86113] server: Introduce integration tests for pubsub Kafka integration

[#86113] CI: Build Kafka SIF alongside rdfm-jwt-auth and mark as artifact

[#86113] CI: Build Apptainer using before_get_sources

[#86113] Update dockerignore

[#86113] server: Add response schemas for pubsub