[Bug] The StarRocks query for the Paimon system table encounters an error

### Search before asking

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

### Paimon version

paimon version 0.8.2

### Compute Engine

starrocks version 3.3.6

### Minimal reproduce step

MySQL [(none)]> select * from `paimon_catalog`.`paimon_db`.`test2$snapshots `;

### What doesn't meet your expectations?

When I use Starrocks SQL to query Paimon's system tables，the error is as follows：
MySQL [(none)]> select * from `paimon_catalog`.`paimon_db`.`test2$snapshots `;
ERROR 1064 (HY000): Invalid metadata table name (unknown type 'snapshots'): test2$snapshots

### Anything else?

_No response_

### Are you willing to submit a PR?

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

Reproduce the exact StarRocks query against Paimon 0.8.2 with StarRocks 3.3.6 and capture the metadata-table name handling that produces the unknown-type error. Trace the relevant system-table query path and compare its handling of the snapshots table with supported metadata tables. Done means the query executes successfully or the supported syntax and limitation are clearly documented.

Written by the indexing model from the issue text.