Found this beta product that allows for automatic sync between cold and hot storage on iceberg and Postgres. The ability to do updates and deletes on cold data with pg syntax is very enticing.

Haven’t used it, wondering if there are similar production ready products