system/classes/Db_MySQL.php
protected function getArrayCondition($dataMember, $statementNum, $offset)
    {
        if (count($this->{$dataMember}[$statementNum][0][$offset]) >= 3) {
            $item = $this->{$dataMember}[$statementNum][0][$offset];
            $result = '';
            
            if ($item[1] == 'IN') {
                $searchArea = $item[2];
                
                // Check if searchArea is array...
                if (is_array($searchArea)) {
                    // Convert the array into a comma delimited string.
                    $str = "'";
                    $size = count($searchArea);
                    for($i=0; $i < $size; $i++) {
                        $str_item = $this->clean($searchArea[$i]);
                        $str = $str.$str_item;
                        if ($i < $size-1) {
                            $str = $str."', '";
                        }
                    }
                    $searchArea = $str."'";
                } else {
                    $searchArea = $this->clean($searchArea);
                }
                
                // Return string of form 'COLUMN IN (value1, value2, ...)'
                $result = $item[0].' '.$item[1]." (".$searchArea.")";
            }
            else {
                // Return string of form 'COLUMN >= VALUE'
                $column = $this->sanitize($item[0], $dataMember);
                if ($item[2] === 'NULL') {
                    $result = $column.' '.$item[1]." ".$item[2]; 
                }
                else {
                    $result = $column.' '.$item[1]." '".$this->clean($item[2])."'";
                }
            }
            return $result;
        }
        else {
            throw new \Exception("Cora's Query Builder class expects advanced query components to be in an array with form {column, operator, value [, conjunction]}");
        }
    }
protected function getArrayCondition($dataMember, $statementNum, $offset)
    {
        if (count($this->{$dataMember}[$statementNum][0][$offset]) >= 3) {
            $item = $this->{$dataMember}[$statementNum][0][$offset];
            $result = '';
            
            if ($item[1] == 'IN') {
                $searchArea = $item[2];
                
                // Check if searchArea is array...
                if (is_array($searchArea)) {
                    // Convert the array into a comma delimited string.
                    $str = "'";
                    $size = count($searchArea);
                    for($i=0; $i < $size; $i++) {
                        $str_item = $this->clean($searchArea[$i]);
                        $str = $str.$str_item;
                        if ($i < $size-1) {
                            $str = $str."', '";
                        }
                    }
                    $searchArea = $str."'";
                } else {
                    $searchArea = $this->clean($searchArea);
                }
                
                // Return string of form 'COLUMN IN (value1, value2, ...)'
                $result = $item[0].' '.$item[1]." (".$searchArea.")";
            }
            else {
                // Return string of form 'COLUMN >= VALUE'
                $column = $this->sanitize($item[0], $dataMember);
                if ($item[2] === 'NULL') {
                    $result = $column.' '.$item[1]." ".$item[2]; 
                }
                else {
                    $result = $column.' '.$item[1]." '".$this->clean($item[2])."'";
                }
            }
            return $result;
        }
        else {
            throw new \Exception("Cora's Query Builder class expects advanced query components to be in an array with form {column, operator, value [, conjunction]}");
        }
    }
When given an array of the following format:
[column, operator, value]
It returns a composite string of the variables.

If any of the three offsets are missing, it with throw an exception.
Some examples of this in use are:
[$column, '=', $value] when getting WHERE or HAVING clause.
[$column, 'IN', array()] when getting column IN array() clause.