Chunk the results of the query.

Execute a callback over each item while chunking.

Chunk the results of a query by comparing IDs.

Execute a callback over each item while chunking by ID.

Execute the query and get the first result.

Apply the callback's query changes if the given "value" is true.

Pass the query to a given callback.

Apply the callback's query changes if the given "value" is false.

Create a new length-aware paginator instance.

Create a new simple paginator instance.

Explains the query.

Forward a method call to the given object.

Throw a bad method call exception for the given method.

Register a custom macro.

Mix another object into the class.

Checks if macro is registered.

Dynamically handle calls to the class.

Dynamically handle calls to the class.

Create a new join clause instance.

Set the columns to be selected.

Add a subselect expression to the query.

Add a new "raw" select expression to the query.

Makes "from" fetch from a subquery.

Add a raw from clause to the query.

Creates a subquery and parse it.

Parse the subquery into SQL and bindings.

Prepend the database name if the given query is on another database.

Add a new select column to the query.

Force the query to only return distinct results.

Set the table which the query is targeting.

Add a join clause to the query.

Add a "join where" clause to the query.

Add a subquery join clause to the query.

Add a left join to the query.

Add a "join where" clause to the query.

Add a subquery left join to the query.

Add a right join to the query.

Add a "right join where" clause to the query.

Add a subquery right join to the query.

Add a "cross join" clause to the query.

Add a subquery cross join to the query.

Get a new join clause.

Merge an array of where clauses and bindings.

Add a basic where clause to the query.

Add an array of where clauses to the query.

Prepare the value and operator for a where clause.

Determine if the given operator and value combination is legal.

Prevents using Null values with invalid operators.

Determine if the given operator is supported.

Add an "or where" clause to the query.

Add a "where" clause comparing two columns to the query.

Add an "or where" clause comparing two columns to the query.

Add a raw where clause to the query.

Add a raw or where clause to the query.

Add a "where in" clause to the query.

Add an "or where in" clause to the query.

Add a "where not in" clause to the query.

Add an "or where not in" clause to the query.

Add a "where in raw" clause for integer values to the query.

Add an "or where in raw" clause for integer values to the query.

Add a "where not in raw" clause for integer values to the query.

Add an "or where not in raw" clause for integer values to the query.

Add a "where null" clause to the query.

Add an "or where null" clause to the query.

Add a "where not null" clause to the query.

Add a where between statement to the query.

Add a where between statement using columns to the query.

Add an or where between statement to the query.

Add an or where between statement using columns to the query.

Add a where not between statement to the query.

Add a where not between statement using columns to the query.

Add an or where not between statement to the query.

Add an or where not between statement using columns to the query.

Add an "or where not null" clause to the query.

Add a "where date" statement to the query.

Add an "or where date" statement to the query.

Add a "where time" statement to the query.

Add an "or where time" statement to the query.

Add a "where day" statement to the query.

Add an "or where day" statement to the query.

Add a "where month" statement to the query.

Add an "or where month" statement to the query.

Add a "where year" statement to the query.

Add an "or where year" statement to the query.

Add a date based (year, month, day, time) statement to the query.

Add a nested where statement to the query.

Create a new query instance for nested where condition.

Add another query builder as a nested where to the query builder.

Add a full sub-select to the query.

Add an exists clause to the query.

Add an or exists clause to the query.

Add a where not exists clause to the query.

Add a where not exists clause to the query.

Add an exists clause to the query.

Adds a where condition using row values.

Adds an or where condition using row values.

Add a "where JSON contains" clause to the query.

Add an "or where JSON contains" clause to the query.

Add a "where JSON not contains" clause to the query.

Add an "or where JSON not contains" clause to the query.

Add a "where JSON length" clause to the query.

Add an "or where JSON length" clause to the query.

Handles dynamic "where" clauses to the query.

Add a single dynamic where clause statement to the query.

Add a "group by" clause to the query.

Add a raw groupBy clause to the query.

Add a "having" clause to the query.

Add an "or having" clause to the query.

Add a "having between " clause to the query.

Add a raw having clause to the query.

Add a raw or having clause to the query.

Add an "order by" clause to the query.

Add a descending "order by" clause to the query.

Add an "order by" clause for a timestamp to the query.

Add an "order by" clause for a timestamp to the query.

Put the query's results in random order.

Add a raw "order by" clause to the query.

Alias to set the "offset" value of the query.

Set the "offset" value of the query.

Alias to set the "limit" value of the query.

Set the "limit" value of the query.

Set the limit and offset for a given page.

Constrain the query to the previous "page" of results before a given ID.

Constrain the query to the next "page" of results after a given ID.

Remove all existing orders and optionally add a new order.

Get an array with all orders with a given column removed.

Add a union statement to the query.

Add a union all statement to the query.

Lock the selected rows in the table.

Lock the selected rows in the table for updating.

Share lock the selected rows in the table.

Get the SQL representation of the query.

Execute a query for a single record by ID.

Get a single column's value from the first result of a query.

Execute the query as a "select" statement.

Run the query as a "select" statement against the connection.

Paginate the given query into a simple paginator.

Get a paginator only supporting simple next and previous links.

This is more efficient on larger data-sets, etc.

Get the count of the total records for the paginator.

Run a pagination count query.

Clone the existing query instance for usage in a pagination subquery.

Remove the column aliases since they will break count queries.

Get a lazy collection for the given query.

Throw an exception if the query doesn't have an orderBy clause.

Get an array with the values of a given column.

Strip off the table name or alias from a column identifier.

Retrieve column values from rows represented as objects.

Retrieve column values from rows represented as arrays.

Concatenate values of a given column as a string.

Determine if any rows exist for the current query.

Determine if no rows exist for the current query.

Execute the given callback if no rows exist for the current query.

Execute the given callback if rows exist for the current query.

Retrieve the "count" result of the query.

Retrieve the minimum value of a given column.

Retrieve the maximum value of a given column.

Retrieve the sum of the values of a given column.

Retrieve the average of the values of a given column.

Alias for the "avg" method.

Execute an aggregate function on the database.

Execute a numeric aggregate function on the database.

Set the aggregate property without running the query.

Execute the given callback while selecting the given columns.

After running the callback, the columns are reset to the original value.

Insert new records into the database.

Insert new records into the database while ignoring errors.

Insert a new record and get the value of the primary key.

Insert new records into the table using a subquery.

Update records in the database.

Insert or update a record matching the attributes, and fill it with values.

Insert new records or update the existing ones.

Increment a column's value by a given amount.

Decrement a column's value by a given amount.

Delete records from the database.

Run a truncate statement on the table.

Get a new instance of the join clause builder.

Create a new query instance for sub-query.

Create a raw database expression.

Get the current query value bindings in a flattened array.

Get the raw array of bindings.

Set the bindings on the query builder.

Add a binding to the query.

Merge an array of bindings into our bindings.

Remove all of the expressions from a list of bindings.

Get the default key name of the table.

Get the database connection instance.

Get the database query processor instance.

Get the query grammar instance.

Use the write pdo for query.

Determine if the value is a query builder instance or a Closure.

Clone the query.

Clone the query without the given properties.

Clone the query without the given bindings.

Dump the current SQL and bindings.

Die and dump the current SQL and bindings.

Add an "on" clause to the join.

On clauses can be chained, e.g.

$join->on('contacts.user_id', '=', 'users.id') ->on('contacts.info_id', '=', 'info.id')

will produce the following SQL:

on contacts.user_id = users.id and contacts.info_id = info.id

Add an "or on" clause to the join.

Create a new parent query instance.