Apart from including the Enterprise features and new statements as the CREATE TABLE AS, with CrateDB v4.5 we've done work behind the scenes—with improvements in the documentation, error messages, and stability.
In this release, we improved the performance and stability of CrateDB, diagnostics, and its standard SQL and Postgres compatibility.
In this post, I will introduce scalar subqueries, explain what challenges we faced extending this feature in CrateDB, and then show you how we addressed those challenges.
Engineering blog post explaining the CrateDB query processing pipeline and recent modifications to improve it.
