IMO this is the best approach for most scenarios. 9 out of 10 it's lightweight enough and powerful enough. ORMs tries to hide the impedance mismatch, but the u

IMO this is the best approach for most scenarios. 9 out of 10 it's lightweight enough and powerful enough. ORMs tries to hide the impedance mismatch, but the underlying paradigm is still relational, which always leads to a leaky abstraction. In contrast, the query builder approach builds DSL to address relational paradigm so that programmer can work with relational paradigm better.