Builder|Builder leftJoinWhere(string $table, string $one, string $operator, string $two) Add a "join where" clause to the query. Parameters string $table string $one string $operator string $two Return Value Builder|Builder

Builder|Builder leftJoin(string $table, string $first, string $operator = null, string $second = null) Add a left join to the query. Parameters string $table string $first string $operator string $second Return Value Builder|Builder

Builder|Builder latest(string $column = 'created_at') Add an "order by" clause for a timestamp to the query. Parameters string $column Return Value Builder|Builder

Builder|Builder joinWhere(string $table, string $one, string $operator, string $two, string $type = 'inner') Add a "join where" clause to the query. Parameters string $table string $one string $operator string $two string $type Return Value Builder|Builder

$this join(string $table, string $one, string $operator = null, string $two = null, string $type = 'inner', bool $where = false) Add a join clause to the query. Parameters string $table string $one string $operator string $two string $type bool $where Return Value $this

int insertGetId(array $values, string $sequence = null) Insert a new record and get the value of the primary key. Parameters array $values string $sequence Return Value int

bool insert(array $values) Insert a new record into the database. Parameters array $values Return Value bool

$this inRandomOrder(string $seed = '') Put the query's results in random order. Parameters string $seed Return Value $this

int increment(string $column, int $amount = 1, array $extra = array()) Increment a column's value by a given amount. Parameters string $column int $amount array $extra Return Value int

string implode(string $column, string $glue = '') Concatenate values of a given column as a string. Parameters string $column string $glue Return Value string