Add async capabilities for memory databases #2

Feature Request

Add support for asynchronous operations in the memory database utilities. The library should be able to create and return async connections to in-memory databases, allowing users to leverage async/await patterns for database interactions.

Requirements:

• Provide async connection creation functions.
• Return async connection objects compatible with common async patterns (e.g. async with, await).
• Ensure backwards compatibility with existing sync APIs.
• Update documentation to explain async usage.

Benefits:

• Enables non-blocking database operations.
• Improves performance in async applications.

Acceptance Criteria:

• Async APIs are tested and documented.
• Example usage added to the docs.