private static $datatype = ['codpes' => 'int', 'numpat' => 'decimal', 'codlocusp' => 'numeric', 'codare' => 'int', 'numofe' => 'int'];

    public static function convert($coluna)
    {
        if (!empty(SELF::$datatype[$coluna])) {
            return 'convert(' . SELF::$datatype[$coluna] . ', :' . $coluna . ')';
        } else {
            return ':'.$coluna;
        }
    }

Chamada:
        $query = "SELECT o.*, d.nomdis, d.numcretotdis
           FROM OFERECIMENTO as o, DISCIPLINA as d
           WHERE o.sgldis = d.sgldis
           AND o.numseqdis = d.numseqdis
           AND o.sgldis = :sgldis
           AND o.numofe = ".DB::convert('numofe')."
           AND o.numseqdis = (SELECT MAX(numseqdis) FROM OFERECIMENTO WHERE sgldis = :sgldis AND numofe = convert(int, :numofe))
        ";