Support querying system tables in paimon-cpp

[suxiaogang223]

According to the official Paimon docs, system tables are first-class query interfaces for table metadata, changelog analysis, and catalog-wide observability:
https://paimon.apache.org/docs/master/concepts/system-tables/

paimon-cpp currently lacks system table query support.
This request is to add system table query support in paimon-cpp, including:

• Data system tables (for example):
  snapshots, schemas, options, audit_log, binlog, ro, files, tags, branches, consumers, manifests, aggregation_fields, partitions, buckets, statistics, table_indexes
• Global system tables under sys (for example):
  tables, partitions, all_table_options, catalog_options

Expected outcome:

• Users can query system tables in C++ environments with behavior aligned to Paimon documentation.
• Core changelog observability use cases (including audit_log and binlog) are covered.
• Metadata and global catalog inspection via system tables are available in paimon-cpp.

[lxy-9602]

Very useful issue — thank you!

The system table part overlaps with catalog logic, so we can wait until the catalog refactor (#84 , #92 ) is complete before moving forward. Changelog support isn't available in paimon-cpp yet, but this would be a great addition.

Would you be open to contributing this feature? We’re happy to help with design and review.

[suxiaogang223]

Hi, thanks for the kind feedback!

I’d be happy to contribute this feature. I’ll start by drafting an implementation/design document so we can align on the approach first. Looking forward to your feedback and guidance during the process.

Thanks again!