Stop using so many CTEs - Blog | Hex

This post introduces and details the functionality of 'Chained SQL' in Hex. It explains how users can reference the output of one SQL cell (a named dataframe) in another SQL cell, with Hex automatically translating this into a CTE. The post highlights the debugging advantages over traditional CTEs, the technical challenge of parsing queries to identify these references, and the seamless integration into the Hex notebook, contrasting it with Dataframe SQL.