Return Iceberg metadata tables in SQLAlchemy reflection

[metadaddy]

Describe the feature

The Iceberg metadata tables, $partitions, $manifests, $files, etc, should be available via SQLAlchemy reflection, perhaps by specifying a dialect-specific keyword such as trino_include_metadata_tables.

There does not currently appear to be a way to get the server to list the metadata tables for an Iceberg table, so the client might just have to 'know' that they exist.

Describe alternatives you've considered

You could hardcode the list of metadata table names into a client app, but this would be vulnerable to changes in the Iceberg connector implementation that might introduce new metadata tables.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[hashhar]

Sounds reasonable to me. Would also be good to check what the JDBC driver's DatabaseMetaData#getTables does for comparison.