Query processing and optimisation are critical components of modern database systems, serving to translate high‐level declarative queries into efficient, low‐level machine instructions. At its core, ...