SQL

How Readyset Rewrites Your SQL: Inside the Query Transformation Pipeline

Vassili Zarouba explains why Readyset's incrementally maintained dataflow cache needs SQL rewritten into canonical forms, and walks through its pipeline of composable, semantics-preserving passes, including array constructor rewrites, redundant join elimination, left-spine hoisting, subquery decorrelation and three-valued logic for IN and NOT IN.

Blog post · Databases · Software Engineering · SQL