Ensure proper handling of asyncio event loops and dispose SQLAlchemy … #251

Job	Run time
test	2m 18s
build-arch (linux/amd64, ubuntu-latest, http)	21s
build-arch (linux/amd64, ubuntu-latest, dramatiq)	32s
build-arch (linux/amd64, ubuntu-latest, socketio)	25s
build-arch (linux/arm64, ubuntu-24.04-arm, socketio)	32s
build-arch (linux/arm64, ubuntu-24.04-arm, dramatiq)	38s
build-arch (linux/arm64, ubuntu-24.04-arm, migrations)	42s
build-arch (linux/arm64, ubuntu-24.04-arm, http)	37s
build-arch (linux/amd64, ubuntu-latest, migrations)	39s
aggregate-manifests (socketio)	27s
aggregate-manifests (dramatiq)	37s
aggregate-manifests (migrations)	29s
aggregate-manifests (http)	40s
	8m 57s

Provide feedback