[cache] Make use of the new pkg/cache package and for all the caching layers in query service

[shivanshuraj1333]

We recently introduced a new cache package in #6733 that supports having CacheableEntity and the whole object can be stored in the Cache.

Previously only Marshaled data was being stored https://github.com/SigNoz/signoz/blob/main/pkg/query-service/cache/inmemory/cache.go#L29

We can now deprecate old cache implementation residing in https://github.com/SigNoz/signoz/blob/main/pkg/query-service/cache/inmemory/cache.go, and can completely use the new Cache package https://github.com/SigNoz/signoz/tree/main/pkg/cache for Redis and in-memory cache.