How to build a query in QueryBuilder in parts?

Question

symfony

Where can I see a good example of building a query/s with a QueryBuilder from "pieces"? I don't know how to put it more clearly. The topic was found by me here https://symfonycasts.com/screencast/symfony-doctri... but only on the example of one method:

private function addIsPublishedQueryBuilder(QueryBuilder $qb)
    {
        return $qb->andWhere('a.publishedAt IS NOT NULL');
    }

... for a clear understanding of this technique, the example given in the article is not enough for me.
I would be very grateful if someone shares their experience. You are welcome! :)

Answer 1

I suspect that the fluent interface was meant by the pieces, something like this then:
$qb->andWhere('a.publishedAt IS NOT NULL')
->andWhere('a.status = :status')
->setParameter('status' , 'gggg');
if ($hhh === $bbb) {
$qb->andWhere('a.hhh = 1')
}
return $qb;

Answer 2

I wrote a builder, this is not a thankful job
About five years ago there was a wrapper around mysqli with fetch and other things
. Then I decided to go only to the builder
https://github.com/Compolomus/SQLQueryBuilder
There is a lot of magic there. But the principle must be clear