Two Kinds of SQL Query Builders
Summary
The article compares data-oriented and syntax-oriented SQL query builders, using FunSQL.jl as a case study. It explains how pipeline design shapes query construction, the effect of node order on results, and how SQL pushdown differs from direct query composition. It argues that FunSQL uniquely exposes the full expressive power of SQL in a data-oriented approach, offering advantages for complex analytics pipelines.