JsonbHashGreaterGreater.php

<?php
namespace Inbep\Doctrine\Query\PostgreSql;

use Doctrine\ORM\Query\AST\Functions\FunctionNode;
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\Parser;
use Doctrine\ORM\Query\SqlWalker;

class JsonbHashGreaterGreater extends FunctionNode
{
    private $expr1 = null;
    private $expr2 = null;

    public function parse(Parser $parser)
    {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->expr1 = $parser->ArithmeticPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->expr2 = $parser->ArithmeticPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
    
    public function getSql(SqlWalker $sqlWalker)
    {
        return '('.
            $this->expr1->dispatch($sqlWalker).' #>> '.
            $this->expr2->dispatch($sqlWalker).
        ')';
    }
}

// how to use
$qb = $this->_em->createQueryBuilder()
->select('u')
->from(User::class, 'u')
->andWhere('u.email = ?1')
->orWhere("JSONB_HGG(u.metadata, '{phones,mobile}') = ?1")
->setParameter(1, $username)
->getQuery()
->getSingleResult();