sum and where conditionals?

[maartenheideman]

Great work makes my code a lot more readable! But some questions: How work with sum and where conditionals? I build a query and need multiple sum items for calculating some totals but how to build that? I don’t want to make multiple queries.

Also I’ll have some filters that can be set or not if not the were clause needs to skipped

[stephenharris]

I guess that we would need to add support for a HAVING clause? You would presumably need to do something like: $qb->select(["summable_column as thesum"])->having('thesum', ">=", 42);

Happy to consider a PR if you have time to provide one :)

[maartenheideman]

I have sent you a personal mail to describe my wish for the Query Builder.