Collection get(array $columns = array('*')) Execute the query as a "select" statement. Parameters array $columns Return Value Collection

$this from(string $table) Set the table which the query is targeting. Parameters string $table Return Value $this

Builder|Builder forPageAfterId(int $perPage = 15, int $lastId, string $column = 'id') Constrain the query to the next "page" of results after a given ID. Parameters int $perPage int $lastId string $column Return Value Builder|Builder

Builder|Builder forPage(int $page, int $perPage = 15) Set the limit and offset for a given page. Parameters int $page int $perPage Return Value Builder|Builder

Builder forNestedWhere() Create a new query instance for nested where condition. Return Value Builder

stdClass|array|null first(array $columns = array('*')) Execute the query and get the first result. Parameters array $columns Return Value stdClass|array|null

mixed|Builder find(int $id, array $columns = array('*')) Execute a query for a single record by ID. Parameters int $id array $columns Return Value mixed|Builder

bool exists() Determine if any rows exist for the current query. Return Value bool

bool each(callable $callback, int $count = 1000) Execute a callback over each item while chunking. Parameters callable $callback int $count Return Value bool Exceptions RuntimeException

$this dynamicWhere(string $method, string $parameters) Handles dynamic "where" clauses to the query. Parameters string $method string $parameters Return Value $this