I think you are a bit out of date, when S3 Tables launched they made the Metadata available using this technology. So you can query it like an Apache Iceberg table.

https://aws.amazon.com/blogs/aws/introducing-queryable-objec...