Amazon Aurora DSQL adds PostgreSQL JSON data type support with compression

AI Impact Summary

Amazon Aurora DSQL has added native support for the PostgreSQL JSON data type, enabling developers to directly utilize existing PostgreSQL JSON tooling and functions. This allows for efficient storage and querying of semi-structured data like API payloads and event logs, which were previously difficult to manage within the Aurora DSQL environment. The default compression enabled with Aurora DSQL further optimizes storage costs for these JSON payloads, representing a significant shift in data management capabilities.