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

public getDistinct () Returns SELECT DISTINCT / SELECT ALL flag

public getDI () Returns the DependencyInjector container

public string | array getColumns () Return the columns to be queried

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 forUpdate (mixed $forUpdate) Sets a FOR UPDATE clause $builder->forUpdate(true);

public distinct (mixed $distinct) Sets SELECT DISTINCT / SELECT ALL flag $builder->distinct("status"); $builder->distinct(null);

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(*)'));

public betweenWhere (mixed $expr, mixed $minimum, mixed $maximum, [mixed $operator]) Appends a BETWEEN condition to the current conditions $builder->betweenWhere('price', 100.25, 200.50);

final public autoescape (mixed $identifier) Automatically escapes identifiers but only if they need to be escaped.