[FEATURE]: Cache built in support for bun Redis client

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

Add Bun redis cache support as a built in feature for drizzle, like we are doing with upstash

Review Drizzle's existing Upstash cache support first, then investigate how the Bun Redis client should integrate with the ORM's cache APIs. Define the expected built-in Bun Redis behavior and verify that the resulting integration works with Bun and Redis.

Written by the indexing model from the issue text.