Related to #26323
I am not sure but #25378 can serve as an optional opt-in.
This enhancement is available from trino v475.
Make it configurable by using the configuration property eg iceberg.optimize-manifests-per-partition.enabled=true|false config prop.
Another idea is to parameterize https://trino.io/docs/current/connector/iceberg.html#optimize-manifests, for example: ALTER TABLE test_table EXECUTE optimize_manifests(manifest_per_partition => true|false);