public string getGroupBy () Returns the GROUP BY clause

public getDistinct () Returns SELECT DISTINCT / SELECT ALL flag

public from (mixed $models) Sets the models who makes part of the query $builder->from('Robots'); $builder->from(array('Robots', 'RobotsParts')); $builder->from(array('r' => 'Robots', 'rp' => 'RobotsParts'));

public getDI () Returns the DependencyInjector container

public forUpdate (mixed $forUpdate) Sets a FOR UPDATE clause $builder->forUpdate(true);

public string | array getFrom () Return the models who makes part of the query

public Phalcon\Mvc\Model\Query\Builder andWhere (string $conditions, [array $bindParams], [array $bindTypes]) Appends a condition to the current conditions using a AND operator $builder->andWhere('name = "Peter"'); $builder->andWhere('name = :name: AND id > :id:', array('name' => 'Peter', 'id' => 100));

public addFrom (mixed $model, [mixed $alias], [mixed $with]) Add a model to take part of the query // Load data from models Robots $builder->addFrom('Robots'); // Load data from model 'Robots' using 'r' as alias in PHQL $builder->addFrom('Robots', 'r'); // Load data from model 'Robots' using 'r' as alias in PHQL // and eager load model 'RobotsParts' $builder->addFrom('Robots', 'r', 'RobotsParts'); // Load data from model 'Robots' using 'r' as alias in PHQL // and eager loa

public columns (mixed $columns) Sets the columns to be queried $builder->columns("id, name"); $builder->columns(array('id', 'name')); $builder->columns(array('name', 'number' => 'COUNT(*)'));

implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub Helps to create PHQL queries using an OO interface $params = array( 'models' => array('Users'), 'columns' => array('id', 'name', 'status'), 'conditions' => array( array( "created > :min: AND created < :max:", array("min" => '2013-01-01', 'max' => '2014-01-01'), array("min" => PDO::PARAM_STR, 'max' =>