PG_LAKEHOUSE

Summary from the TLDR newsletter

pg_lakehouse is an extension that transforms Postgres into an analytical query engine over object stores. Querying non-operational data by moving it into a cloud data warehouse or operating a new query engine is expensive and time-consuming. pg_lakehouse allows this data to be queried directly from Postgres, eliminating the need for new infrastructure, loss of data freshness, data movement, and non-Postgres dialects of other query engines.