Custom DQL functions

bootstrap.php

$config = new Doctrine\ORM\Configuration();
[...]
// add custom DQL extensions
$config->addCustomStringFunction('NVL',	'DqlNvl');
$config->addCustomStringFunction('CONVERT', 'DqlConvert');
$config->addCustomStringFunction('TO_NUMBER', 'DqlToNumber');

DqlConvert.php

<?php
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\AST\Functions\FunctionNode;

class DqlConvert extends FunctionNode {
	
    public $field;
	
    public $convertMode;

    public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) {
        return 'CONVERT(' .
            $this->field->dispatch($sqlWalker) . ', ' .
            $this->convertMode->dispatch($sqlWalker) .
        ')';
    }

    public function parse(\Doctrine\ORM\Query\Parser $parser) {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->field = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->convertMode = $parser->ArithmeticPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

DqlNvl.php

<?php
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\AST\Functions\FunctionNode;

class DqlNvl extends FunctionNode {
	
    public $field;
	
    public $fallback;

    public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) {
        return 'NVL(' .
            $this->field->dispatch($sqlWalker) . ', ' .
            $this->fallback->dispatch($sqlWalker) .
        ')';
    }

    public function parse(\Doctrine\ORM\Query\Parser $parser) {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->field = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->fallback = $parser->StringPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

DqlToNumber.php

<?php
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\AST\Functions\FunctionNode;

class DqlToNumber extends FunctionNode {
	
    public $field;

    public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) {
        return 'TO_NUMBER(' .
            $this->field->dispatch($sqlWalker) .
        ')';
    }

    public function parse(\Doctrine\ORM\Query\Parser $parser) {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);
        $this->field = $parser->StringPrimary();
        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}