new feature: capability `list` for redb

### Feature Description

Allowing to call `list/lister` on redb backend.

### Problem and Solution

I need to traverse all elements in a redb table.

### Additional Context

_No response_

### Are you willing to contribute to the development of this feature?

- [x] Yes, I am willing to contribute to the development of this feature.

Start by locating the redb backend and its existing capability implementations, then inspect how list/lister operations are handled by comparable backends. The work is done when callers can traverse all elements in a redb table through the list capability and the relevant behavior is covered by tests.

Written by the indexing model from the issue text.