The latest release of ksqlDB, version 0.19.0, introduces a significant enhancement with the inclusion of foreign-key joins, a highly anticipated feature that allows for many-to-one relationships between tables, previously only achievable through workarounds. This update does not require new syntax and enables users to specify any left-hand table column in the join condition, facilitating more flexible data modeling without a co-partitioning requirement, while still supporting INNER or LEFT OUTER join semantics. Additionally, the release includes a community-contributed NULLIF function, which returns NULL when its arguments are equal, offering a utility for transforming specific values into NULL. These advancements are poised to broaden the use cases for ksqlDB, making data processing more versatile and efficient, while also building on the enhanced stateful processing capabilities introduced in Kafka Streams 3.5, which allow for storing multiple record versions per key.