[Feature] Add filename->manifest entry system table and support batch/streaming read

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

subtask of #7284

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

No implementation files, tests, or concrete solution are named. Start with the parent issue #7284 and identify the relevant system-table entry points; done means adding the filename-to-manifest entry system table with both batch and streaming read support.

Written by the indexing model from the issue text.