Is your feature request related to a problem? Please describe.
DatabaseSessionService uses async method signatures but internally calls SQLAlchemy’s sync APIs

Describe the solution you'd like
Add an AsyncDatabaseSessionService that uses SQLAlchemy’s async APIs (AsyncSession, etc.).

Describe alternatives you've considered
Fix existing DatabaseSessionService implementation to use async database operations.

Additional context
n/a