upgrade to async DB connections

[ericbuckley]

Summary

All of our API endpoints require communication with the database, our sync DB drivers prevent us from upgrading these API endpoints to async and making performance gains.

Acceptance Criteria

• Update the 4 dialect drivers (sqlite, postgres, mysql and sqlserver) to use asnyc versions
• Rewrite all public methods in database/*_service.py modules to have async signatures

Details / Tasks

List the subtasks or steps needed to complete this implementation.

1. Task 1
2. Task 2
3. Task 3

Background / Context

Provide any additional context, background information, or references that might be useful for understanding the issue.

Dependencies

List any dependencies this issue has, such as other tasks, libraries, or third-party services.

Testing Considerations

Explain how this feature will be tested. Mention if there are any specific test cases to be written or existing ones to be modified.

Related Issues/PRs

• Link to related issues or pull requests if applicable.

Notes / Comments

Any other relevant information or clarifications.