JoinClause

Chunk the results of the query.

Execute a callback over each item while chunking.

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.

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.

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.

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 with a sub-select to the query.

Add an external sub-select 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 an or where between statement to the query.

Add a where not between statement to the query.

Add an or where not between statement 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 a or where condition using row values.

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

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

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

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

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

Add a "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 "having" clause to the query.

Add a "or having" 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 next "page" of results after a given ID.

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.

Remove the column aliases since they will break count queries.

Get a generator for the given query.

Chunk the results of a query by comparing numeric IDs.

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.

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 a new record into the database.

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

Update a record in the database.

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

Increment a column's value by a given amount.

Decrement a column's value by a given amount.

Delete a record 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 database connection instance.

Get the database query processor instance.

Get the query grammar instance.

Use the write pdo for query.

Clone the query without the given properties.

Clone the query without the given 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.