Enhance Query Caching for Repeated Queries

[T-Ezzoury]

Description: In some use cases, users often re-execute similar queries. Implementing an enhanced caching mechanism for frequent queries could help reduce response times and resource usage.

Expected Behavior: Query results should be cached for a specified duration, allowing repeated queries to retrieve results quickly without re-execution.

Potential Solutions: Implement a memory-based cache with configurable expiration and support for invalidation triggers.