Advanced Database Query Caching with Redis Optimization

Develop a sophisticated query caching mechanism using Redis and SQLAlchemy that intelligently manages cache invalidation for complex database queries. Create a decorator-based system that can handle different cache expiration strategies, supports partial query result caching, and provides granular control over cache key generation. Include error handling for cache failures and a fallback mechanism to direct database queries.