 Builder   class Builder (View source)  Traits    BuildsQueries      ForwardsCalls      Macroable     Properties    static protected array  $macros The registered string macros. from  Macroable    ConnectionInterface  $connection The database connection instance.     Grammar  $grammar The database query grammar instance.     Processor  $processor The database query post processor instance.     array  $bindings The current query value bindings.     array  $aggregate An aggregate function and column to be run.     array  $columns The columns that should be returned.     bool|array  $distinct Indicates if the query returns distinct results.     string  $from The table which the query is targeting.     array  $joins The table joins for the query.     array  $wheres The where constraints for the query.     array  $groups The groupings for the query.     array  $havings The having constraints for the query.     array  $orders The orderings for the query.     int  $limit The maximum number of records to return.     int  $offset The number of records to skip.     array  $unions The query union statements.     int  $unionLimit The maximum number of union records to return.     int  $unionOffset The number of union records to skip.     array  $unionOrders The orderings for the union query.     string|bool  $lock Indicates whether row locking is being used.     array  $operators All of the available clause operators.     bool  $useWritePdo Whether use write pdo for select.    Methods    bool   chunk(int $count, callable $callback) Chunk the results of the query.  from  BuildsQueries    bool   each(callable $callback, int $count = 1000) Execute a callback over each item while chunking.  from  BuildsQueries    bool   chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null) Chunk the results of a query by comparing IDs.  from  BuildsQueries    bool   eachById(callable $callback, int $count = 1000, string|null $column = null, string|null $alias = null) Execute a callback over each item while chunking by id.  from  BuildsQueries    Model|object|BuildsQueries|null   first(array|string $columns = ['*']) Execute the query and get the first result.  from  BuildsQueries    mixed|$this   when(mixed $value, callable $callback, callable|null $default = null) Apply the callback's query changes if the given "value" is true.  from  BuildsQueries    $this   tap(callable $callback) Pass the query to a given callback.  from  BuildsQueries    mixed|$this   unless(mixed $value, callable $callback, callable|null $default = null) Apply the callback's query changes if the given "value" is false.  from  BuildsQueries    LengthAwarePaginator   paginator(Collection $items, int $total, int $perPage, int $currentPage, array $options) Create a new length-aware paginator instance.  from  BuildsQueries    Paginator   simplePaginator(Collection $items, int $perPage, int $currentPage, array $options) Create a new simple paginator instance.  from  BuildsQueries    mixed   forwardCallTo(mixed $object, string $method, array $parameters) Forward a method call to the given object.  from  ForwardsCalls    static void   throwBadMethodCallException(string $method) Throw a bad method call exception for the given method.  from  ForwardsCalls    static void   macro(string $name, object|callable $macro) Register a custom macro.  from  Macroable    static void   mixin(object $mixin, bool $replace = true) Mix another object into the class.  from  Macroable    static bool   hasMacro(string $name) Checks if macro is registered.  from  Macroable    static mixed   __callStatic(string $method, array $parameters) Dynamically handle calls to the class.  from  Macroable    mixed   __call(string $method, array $parameters) Handle dynamic method calls into the method.      void   __construct(ConnectionInterface $connection, Grammar $grammar = null, Processor $processor = null) Create a new query builder instance.      $this   select(array|mixed $columns = ['*']) Set the columns to be selected.      Builder|Builder   selectSub(Closure|$this|string $query, string $as) Add a subselect expression to the query.      Builder|Builder   selectRaw(string $expression, array $bindings = []) Add a new "raw" select expression to the query.      Builder|Builder   fromSub(Closure|Builder|string $query, string $as) Makes "from" fetch from a subquery.      Builder|Builder   fromRaw(string $expression, mixed $bindings = []) Add a raw from clause to the query.      array   createSub(Closure|Builder|string $query) Creates a subquery and parse it.      array   parseSub(mixed $query) Parse the subquery into SQL and bindings.      $this   addSelect(array|mixed $column) Add a new select column to the query.      $this   distinct() Force the query to only return distinct results.      $this   from(Closure|Builder|string $table, string|null $as = null) Set the table which the query is targeting.      $this   join(string $table, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false) Add a join clause to the query.      Builder|Builder   joinWhere(string $table, Closure|string $first, string $operator, string $second, string $type = 'inner') Add a "join where" clause to the query.      Builder|Builder   joinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false) Add a subquery join clause to the query.      Builder|Builder   leftJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null) Add a left join to the query.      Builder|Builder   leftJoinWhere(string $table, Closure|string $first, string $operator, string $second) Add a "join where" clause to the query.      Builder|Builder   leftJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null) Add a subquery left join to the query.      Builder|Builder   rightJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null) Add a right join to the query.      Builder|Builder   rightJoinWhere(string $table, Closure|string $first, string $operator, string $second) Add a "right join where" clause to the query.      Builder|Builder   rightJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null) Add a subquery right join to the query.      Builder|Builder   crossJoin(string $table, Closure|string|null $first = null, string|null $operator = null, string|null $second = null) Add a "cross join" clause to the query.      JoinClause   newJoinClause(Builder $parentQuery, string $type, string $table) Get a new join clause.      void   mergeWheres(array $wheres, array $bindings) Merge an array of where clauses and bindings.      $this   where(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and') Add a basic where clause to the query.      $this   addArrayOfWheres(array $column, string $boolean, string $method = 'where') Add an array of where clauses to the query.      array   prepareValueAndOperator(string $value, string $operator, bool $useDefault = false) Prepare the value and operator for a where clause.      bool   invalidOperatorAndValue(string $operator, mixed $value) Determine if the given operator and value combination is legal.      bool   invalidOperator(string $operator) Determine if the given operator is supported.      Builder|Builder   orWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null) Add an "or where" clause to the query.      Builder|Builder   whereColumn(string|array $first, string|null $operator = null, string|null $second = null, string|null $boolean = 'and') Add a "where" clause comparing two columns to the query.      Builder|Builder   orWhereColumn(string|array $first, string|null $operator = null, string|null $second = null) Add an "or where" clause comparing two columns to the query.      $this   whereRaw(string $sql, mixed $bindings = [], string $boolean = 'and') Add a raw where clause to the query.      Builder|Builder   orWhereRaw(string $sql, mixed $bindings = []) Add a raw or where clause to the query.      $this   whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false) Add a "where in" clause to the query.      Builder|Builder   orWhereIn(string $column, mixed $values) Add an "or where in" clause to the query.      Builder|Builder   whereNotIn(string $column, mixed $values, string $boolean = 'and') Add a "where not in" clause to the query.      Builder|Builder   orWhereNotIn(string $column, mixed $values) Add an "or where not in" clause to the query.      $this   whereIntegerInRaw(string $column, Arrayable|array $values, string $boolean = 'and', bool $not = false) Add a "where in raw" clause for integer values to the query.      $this   whereIntegerNotInRaw(string $column, Arrayable|array $values, string $boolean = 'and') Add a "where not in raw" clause for integer values to the query.      $this   whereNull(string|array $columns, string $boolean = 'and', bool $not = false) Add a "where null" clause to the query.      Builder|Builder   orWhereNull(string $column) Add an "or where null" clause to the query.      Builder|Builder   whereNotNull(string|array $columns, string $boolean = 'and') Add a "where not null" clause to the query.      $this   whereBetween(string $column, array $values, string $boolean = 'and', bool $not = false) Add a where between statement to the query.      Builder|Builder   orWhereBetween(string $column, array $values) Add an or where between statement to the query.      Builder|Builder   whereNotBetween(string $column, array $values, string $boolean = 'and') Add a where not between statement to the query.      Builder|Builder   orWhereNotBetween(string $column, array $values) Add an or where not between statement to the query.      Builder|Builder   orWhereNotNull(string $column) Add an "or where not null" clause to the query.      Builder|Builder   whereDate(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and') Add a "where date" statement to the query.      Builder|Builder   orWhereDate(string $column, string $operator, DateTimeInterface|string|null $value = null) Add an "or where date" statement to the query.      Builder|Builder   whereTime(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and') Add a "where time" statement to the query.      Builder|Builder   orWhereTime(string $column, string $operator, DateTimeInterface|string|null $value = null) Add an "or where time" statement to the query.      Builder|Builder   whereDay(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and') Add a "where day" statement to the query.      Builder|Builder   orWhereDay(string $column, string $operator, DateTimeInterface|string|null $value = null) Add an "or where day" statement to the query.      Builder|Builder   whereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and') Add a "where month" statement to the query.      Builder|Builder   orWhereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null) Add an "or where month" statement to the query.      Builder|Builder   whereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null, string $boolean = 'and') Add a "where year" statement to the query.      Builder|Builder   orWhereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null) Add an "or where year" statement to the query.      $this   addDateBasedWhere(string $type, string $column, string $operator, mixed $value, string $boolean = 'and') Add a date based (year, month, day, time) statement to the query.      Builder|Builder   whereNested(Closure $callback, string $boolean = 'and') Add a nested where statement to the query.      Builder   forNestedWhere() Create a new query instance for nested where condition.      $this   addNestedWhereQuery(Builder|Builder $query, string $boolean = 'and') Add another query builder as a nested where to the query builder.      $this   whereSub(string $column, string $operator, Closure $callback, string $boolean) Add a full sub-select to the query.      $this   whereExists(Closure $callback, string $boolean = 'and', bool $not = false) Add an exists clause to the query.      Builder|Builder   orWhereExists(Closure $callback, bool $not = false) Add an or exists clause to the query.      Builder|Builder   whereNotExists(Closure $callback, string $boolean = 'and') Add a where not exists clause to the query.      Builder|Builder   orWhereNotExists(Closure $callback) Add a where not exists clause to the query.      $this   addWhereExistsQuery(Builder $query, string $boolean = 'and', bool $not = false) Add an exists clause to the query.      $this   whereRowValues(array $columns, string $operator, array $values, string $boolean = 'and') Adds a where condition using row values.      $this   orWhereRowValues(array $columns, string $operator, array $values) Adds a or where condition using row values.      $this   whereJsonContains(string $column, mixed $value, string $boolean = 'and', bool $not = false) Add a "where JSON contains" clause to the query.      $this   orWhereJsonContains(string $column, mixed $value) Add a "or where JSON contains" clause to the query.      $this   whereJsonDoesntContain(string $column, mixed $value, string $boolean = 'and') Add a "where JSON not contains" clause to the query.      $this   orWhereJsonDoesntContain(string $column, mixed $value) Add a "or where JSON not contains" clause to the query.      $this   whereJsonLength(string $column, mixed $operator, mixed $value = null, string $boolean = 'and') Add a "where JSON length" clause to the query.      $this   orWhereJsonLength(string $column, mixed $operator, mixed $value = null) Add a "or where JSON length" clause to the query.      $this   dynamicWhere(string $method, array $parameters) Handles dynamic "where" clauses to the query.      void   addDynamic(string $segment, string $connector, array $parameters, int $index) Add a single dynamic where clause statement to the query.      $this   groupBy(array|string ...$groups) Add a "group by" clause to the query.      $this   groupByRaw(string $sql, array $bindings = []) Add a raw groupBy clause to the query.      $this   having(string $column, string|null $operator = null, string|null $value = null, string $boolean = 'and') Add a "having" clause to the query.      Builder|Builder   orHaving(string $column, string|null $operator = null, string|null $value = null) Add a "or having" clause to the query.      Builder|Builder   havingBetween(string $column, array $values, string $boolean = 'and', bool $not = false) Add a "having between " clause to the query.      $this   havingRaw(string $sql, array $bindings = [], string $boolean = 'and') Add a raw having clause to the query.      Builder|Builder   orHavingRaw(string $sql, array $bindings = []) Add a raw or having clause to the query.      $this   orderBy(Closure|Builder|Expression|string $column, string $direction = 'asc') Add an "order by" clause to the query.      $this   orderByDesc(string $column) Add a descending "order by" clause to the query.      Builder|Builder   latest(string $column = 'created_at') Add an "order by" clause for a timestamp to the query.      Builder|Builder   oldest(string $column = 'created_at') Add an "order by" clause for a timestamp to the query.      $this   inRandomOrder(string $seed = '') Put the query's results in random order.      $this   orderByRaw(string $sql, array $bindings = []) Add a raw "order by" clause to the query.      Builder|Builder   skip(int $value) Alias to set the "offset" value of the query.      $this   offset(int $value) Set the "offset" value of the query.      Builder|Builder   take(int $value) Alias to set the "limit" value of the query.      $this   limit(int $value) Set the "limit" value of the query.      Builder|Builder   forPage(int $page, int $perPage = 15) Set the limit and offset for a given page.      Builder|Builder   forPageBeforeId(int $perPage = 15, int|null $lastId = 0, string $column = 'id') Constrain the query to the previous "page" of results before a given ID.      Builder|Builder   forPageAfterId(int $perPage = 15, int|null $lastId = 0, string $column = 'id') Constrain the query to the next "page" of results after a given ID.      array   removeExistingOrdersFor(string $column) Get an array with all orders with a given column removed.      Builder|Builder   union(Builder|Closure $query, bool $all = false) Add a union statement to the query.      Builder|Builder   unionAll(Builder|Closure $query) Add a union all statement to the query.      $this   lock(string|bool $value = true) Lock the selected rows in the table.      Builder   lockForUpdate() Lock the selected rows in the table for updating.      Builder   sharedLock() Share lock the selected rows in the table.      string   toSql() Get the SQL representation of the query.      mixed|Builder   find(int|string $id, array $columns = ['*']) Execute a query for a single record by ID.      mixed   value(string $column) Get a single column's value from the first result of a query.      Collection   get(array|string $columns = ['*']) Execute the query as a "select" statement.      array   runSelect() Run the query as a "select" statement against the connection.      LengthAwarePaginator   paginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null) Paginate the given query into a simple paginator.      Paginator   simplePaginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null) Get a paginator only supporting simple next and previous links.      int   getCountForPagination(array $columns = ['*']) Get the count of the total records for the paginator.      array   runPaginationCountQuery(array $columns = ['*']) Run a pagination count query.      array   withoutSelectAliases(array $columns) Remove the column aliases since they will break count queries.      LazyCollection   cursor() Get a lazy collection for the given query.      void   enforceOrderBy() Throw an exception if the query doesn't have an orderBy clause.      Collection   pluck(string $column, string|null $key = null) Get an array with the values of a given column.      string|null   stripTableForPluck(string $column) Strip off the table name or alias from a column identifier.      Collection   pluckFromObjectColumn(array $queryResult, string $column, string $key) Retrieve column values from rows represented as objects.      Collection   pluckFromArrayColumn(array $queryResult, string $column, string $key) Retrieve column values from rows represented as arrays.      string   implode(string $column, string $glue = '') Concatenate values of a given column as a string.      bool   exists() Determine if any rows exist for the current query.      bool   doesntExist() Determine if no rows exist for the current query.      mixed   existsOr(Closure $callback) Execute the given callback if no rows exist for the current query.      mixed   doesntExistOr(Closure $callback) Execute the given callback if rows exist for the current query.      int   count(string $columns = '*') Retrieve the "count" result of the query.      mixed   min(string $column) Retrieve the minimum value of a given column.      mixed   max(string $column) Retrieve the maximum value of a given column.      mixed   sum(string $column) Retrieve the sum of the values of a given column.      mixed   avg(string $column) Retrieve the average of the values of a given column.      mixed   average(string $column) Alias for the "avg" method.      mixed   aggregate(string $function, array $columns = ['*']) Execute an aggregate function on the database.      float|int   numericAggregate(string $function, array $columns = ['*']) Execute a numeric aggregate function on the database.      $this   setAggregate(string $function, array $columns) Set the aggregate property without running the query.      mixed   onceWithColumns(array $columns, callable $callback) Execute the given callback while selecting the given columns.      bool   insert(array $values) Insert a new record into the database.      int   insertOrIgnore(array $values) Insert a new record into the database while ignoring errors.      int   insertGetId(array $values, string|null $sequence = null) Insert a new record and get the value of the primary key.      int   insertUsing(array $columns, Closure|Builder|string $query) Insert new records into the table using a subquery.      int   update(array $values) Update a record in the database.      bool   updateOrInsert(array $attributes, array $values = []) Insert or update a record matching the attributes, and fill it with values.      int   increment(string $column, float|int $amount = 1, array $extra = []) Increment a column's value by a given amount.      int   decrement(string $column, float|int $amount = 1, array $extra = []) Decrement a column's value by a given amount.      int   delete(mixed $id = null) Delete a record from the database.      void   truncate() Run a truncate statement on the table.      Builder   newQuery() Get a new instance of the query builder.      Builder   forSubQuery() Create a new query instance for a sub-query.      Expression   raw(mixed $value) Create a raw database expression.      array   getBindings() Get the current query value bindings in a flattened array.      array   getRawBindings() Get the raw array of bindings.      $this   setBindings(array $bindings, string $type = 'where') Set the bindings on the query builder.      $this   addBinding(mixed $value, string $type = 'where') Add a binding to the query.      $this   mergeBindings(Builder $query) Merge an array of bindings into our bindings.      array   cleanBindings(array $bindings) Remove all of the expressions from a list of bindings.      string   defaultKeyName() Get the default key name of the table.      ConnectionInterface   getConnection() Get the database connection instance.      Processor   getProcessor() Get the database query processor instance.      Grammar   getGrammar() Get the query grammar instance.      $this   useWritePdo() Use the write pdo for query.      bool   isQueryable(mixed $value) Determine if the value is a query builder instance or a Closure.      Builder   cloneWithout(array $properties) Clone the query without the given properties.      Builder   cloneWithoutBindings(array $except) Clone the query without the given bindings.      $this   dump() Dump the current SQL and bindings.      void   dd() Die and dump the current SQL and bindings.     Details                        bool
    chunk(int $count, callable $callback)
            Chunk the results of the query.   Parameters   int $count    callable $callback    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                              bool
    chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null)
            Chunk the results of a query by comparing IDs.   Parameters   int $count    callable $callback    string|null $column    string|null $alias    Return Value   bool                              bool
    eachById(callable $callback, int $count = 1000, string|null $column = null, string|null $alias = null)
            Execute a callback over each item while chunking by id.   Parameters   callable $callback    int $count    string|null $column    string|null $alias    Return Value   bool         Model|object|BuildsQueries|null
    first(array|string $columns = ['*'])
            Execute the query and get the first result.   Parameters   array|string $columns    Return Value   
Model|object|BuildsQueries|null                              mixed|$this
    when(mixed $value, callable $callback, callable|null $default = null)
            Apply the callback's query changes if the given "value" is true.   Parameters   mixed $value    callable $callback    callable|null $default    Return Value   mixed|$this                              $this
    tap(callable $callback)
            Pass the query to a given callback.   Parameters   callable $callback    Return Value   $this                              mixed|$this
    unless(mixed $value, callable $callback, callable|null $default = null)
            Apply the callback's query changes if the given "value" is false.   Parameters   mixed $value    callable $callback    callable|null $default    Return Value   mixed|$this                      protected        LengthAwarePaginator
    paginator(Collection $items, int $total, int $perPage, int $currentPage, array $options)
            Create a new length-aware paginator instance.   Parameters   Collection $items    int $total    int $perPage    int $currentPage    array $options    Return Value   LengthAwarePaginator                      protected        Paginator
    simplePaginator(Collection $items, int $perPage, int $currentPage, array $options)
            Create a new simple paginator instance.   Parameters   Collection $items    int $perPage    int $currentPage    array $options    Return Value   Paginator                      protected        mixed
    forwardCallTo(mixed $object, string $method, array $parameters)
            Forward a method call to the given object.   Parameters   mixed $object    string $method    array $parameters    Return Value   mixed    Exceptions   BadMethodCallException                  static    protected        void
    throwBadMethodCallException(string $method)
            Throw a bad method call exception for the given method.   Parameters   string $method    Return Value   void    Exceptions   BadMethodCallException                  static            void
    macro(string $name, object|callable $macro)
            Register a custom macro.   Parameters   string $name    object|callable $macro    Return Value   void                  static            void
    mixin(object $mixin, bool $replace = true)
            Mix another object into the class.   Parameters   object $mixin    bool $replace    Return Value   void    Exceptions   ReflectionException                  static            bool
    hasMacro(string $name)
            Checks if macro is registered.   Parameters   string $name    Return Value   bool                  static            mixed
    __callStatic(string $method, array $parameters)
            Dynamically handle calls to the class.   Parameters   string $method    array $parameters    Return Value   mixed    Exceptions   BadMethodCallException                              mixed
    __call(string $method, array $parameters)
            Handle dynamic method calls into the method.   Parameters   string $method    array $parameters    Return Value   mixed    Exceptions   BadMethodCallException                              void
    __construct(ConnectionInterface $connection, Grammar $grammar = null, Processor $processor = null)
            Create a new query builder instance.   Parameters   ConnectionInterface $connection    Grammar $grammar    Processor $processor    Return Value   void                              $this
    select(array|mixed $columns = ['*'])
            Set the columns to be selected.   Parameters   array|mixed $columns    Return Value   $this         Builder|Builder
    selectSub(Closure|$this|string $query, string $as)
            Add a subselect expression to the query.   Parameters   
Closure|$this|string $query    string $as    Return Value   
Builder|Builder
    Exceptions   InvalidArgumentException         Builder|Builder
    selectRaw(string $expression, array $bindings = [])
            Add a new "raw" select expression to the query.   Parameters   string $expression    array $bindings    Return Value   
Builder|Builder
         Builder|Builder
    fromSub(Closure|Builder|string $query, string $as)
            Makes "from" fetch from a subquery.   Parameters   
Closure|Builder|string $query    string $as    Return Value   
Builder|Builder
    Exceptions   InvalidArgumentException         Builder|Builder
    fromRaw(string $expression, mixed $bindings = [])
            Add a raw from clause to the query.   Parameters   string $expression    mixed $bindings    Return Value   
Builder|Builder
                      protected        array
    createSub(Closure|Builder|string $query)
            Creates a subquery and parse it.   Parameters   
Closure|Builder|string $query    Return Value   array                      protected        array
    parseSub(mixed $query)
            Parse the subquery into SQL and bindings.   Parameters   mixed $query    Return Value   array    Exceptions   InvalidArgumentException                              $this
    addSelect(array|mixed $column)
            Add a new select column to the query.   Parameters   array|mixed $column    Return Value   $this                              $this
    distinct()
            Force the query to only return distinct results.   Return Value   $this                              $this
    from(Closure|Builder|string $table, string|null $as = null)
            Set the table which the query is targeting.   Parameters   
Closure|Builder|string $table    string|null $as    Return Value   $this                              $this
    join(string $table, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false)
            Add a join clause to the query.   Parameters   string $table    
Closure|string $first    string|null $operator    string|null $second    string $type    bool $where    Return Value   $this         Builder|Builder
    joinWhere(string $table, Closure|string $first, string $operator, string $second, string $type = 'inner')
            Add a "join where" clause to the query.   Parameters   string $table    
Closure|string $first    string $operator    string $second    string $type    Return Value   
Builder|Builder
         Builder|Builder
    joinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false)
            Add a subquery join clause to the query.   Parameters   
Closure|Builder|string $query    string $as    
Closure|string $first    string|null $operator    string|null $second    string $type    bool $where    Return Value   
Builder|Builder
    Exceptions   InvalidArgumentException         Builder|Builder
    leftJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)
            Add a left join to the query.   Parameters   string $table    
Closure|string $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
         Builder|Builder
    leftJoinWhere(string $table, Closure|string $first, string $operator, string $second)
            Add a "join where" clause to the query.   Parameters   string $table    
Closure|string $first    string $operator    string $second    Return Value   
Builder|Builder
         Builder|Builder
    leftJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null)
            Add a subquery left join to the query.   Parameters   
Closure|Builder|string $query    string $as    
Closure|string $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
         Builder|Builder
    rightJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)
            Add a right join to the query.   Parameters   string $table    
Closure|string $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
         Builder|Builder
    rightJoinWhere(string $table, Closure|string $first, string $operator, string $second)
            Add a "right join where" clause to the query.   Parameters   string $table    
Closure|string $first    string $operator    string $second    Return Value   
Builder|Builder
         Builder|Builder
    rightJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null)
            Add a subquery right join to the query.   Parameters   
Closure|Builder|string $query    string $as    
Closure|string $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
         Builder|Builder
    crossJoin(string $table, Closure|string|null $first = null, string|null $operator = null, string|null $second = null)
            Add a "cross join" clause to the query.   Parameters   string $table    
Closure|string|null $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
                      protected        JoinClause
    newJoinClause(Builder $parentQuery, string $type, string $table)
            Get a new join clause.   Parameters   Builder $parentQuery    string $type    string $table    Return Value   JoinClause                              void
    mergeWheres(array $wheres, array $bindings)
            Merge an array of where clauses and bindings.   Parameters   array $wheres    array $bindings    Return Value   void                              $this
    where(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')
            Add a basic where clause to the query.   Parameters   
Closure|string|array $column    mixed $operator    mixed $value    string $boolean    Return Value   $this                      protected        $this
    addArrayOfWheres(array $column, string $boolean, string $method = 'where')
            Add an array of where clauses to the query.   Parameters   array $column    string $boolean    string $method    Return Value   $this                              array
    prepareValueAndOperator(string $value, string $operator, bool $useDefault = false)
            Prepare the value and operator for a where clause.   Parameters   string $value    string $operator    bool $useDefault    Return Value   array    Exceptions   InvalidArgumentException                      protected        bool
    invalidOperatorAndValue(string $operator, mixed $value)
            Determine if the given operator and value combination is legal. Prevents using Null values with invalid operators.   Parameters   string $operator    mixed $value    Return Value   bool                      protected        bool
    invalidOperator(string $operator)
            Determine if the given operator is supported.   Parameters   string $operator    Return Value   bool         Builder|Builder
    orWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null)
            Add an "or where" clause to the query.   Parameters   
Closure|string|array $column    mixed $operator    mixed $value    Return Value   
Builder|Builder
         Builder|Builder
    whereColumn(string|array $first, string|null $operator = null, string|null $second = null, string|null $boolean = 'and')
            Add a "where" clause comparing two columns to the query.   Parameters   string|array $first    string|null $operator    string|null $second    string|null $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereColumn(string|array $first, string|null $operator = null, string|null $second = null)
            Add an "or where" clause comparing two columns to the query.   Parameters   string|array $first    string|null $operator    string|null $second    Return Value   
Builder|Builder
                              $this
    whereRaw(string $sql, mixed $bindings = [], string $boolean = 'and')
            Add a raw where clause to the query.   Parameters   string $sql    mixed $bindings    string $boolean    Return Value   $this         Builder|Builder
    orWhereRaw(string $sql, mixed $bindings = [])
            Add a raw or where clause to the query.   Parameters   string $sql    mixed $bindings    Return Value   
Builder|Builder
                              $this
    whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)
            Add a "where in" clause to the query.   Parameters   string $column    mixed $values    string $boolean    bool $not    Return Value   $this         Builder|Builder
    orWhereIn(string $column, mixed $values)
            Add an "or where in" clause to the query.   Parameters   string $column    mixed $values    Return Value   
Builder|Builder
         Builder|Builder
    whereNotIn(string $column, mixed $values, string $boolean = 'and')
            Add a "where not in" clause to the query.   Parameters   string $column    mixed $values    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereNotIn(string $column, mixed $values)
            Add an "or where not in" clause to the query.   Parameters   string $column    mixed $values    Return Value   
Builder|Builder
                              $this
    whereIntegerInRaw(string $column, Arrayable|array $values, string $boolean = 'and', bool $not = false)
            Add a "where in raw" clause for integer values to the query.   Parameters   string $column    
Arrayable|array $values    string $boolean    bool $not    Return Value   $this                              $this
    whereIntegerNotInRaw(string $column, Arrayable|array $values, string $boolean = 'and')
            Add a "where not in raw" clause for integer values to the query.   Parameters   string $column    
Arrayable|array $values    string $boolean    Return Value   $this                              $this
    whereNull(string|array $columns, string $boolean = 'and', bool $not = false)
            Add a "where null" clause to the query.   Parameters   string|array $columns    string $boolean    bool $not    Return Value   $this         Builder|Builder
    orWhereNull(string $column)
            Add an "or where null" clause to the query.   Parameters   string $column    Return Value   
Builder|Builder
         Builder|Builder
    whereNotNull(string|array $columns, string $boolean = 'and')
            Add a "where not null" clause to the query.   Parameters   string|array $columns    string $boolean    Return Value   
Builder|Builder
                              $this
    whereBetween(string $column, array $values, string $boolean = 'and', bool $not = false)
            Add a where between statement to the query.   Parameters   string $column    array $values    string $boolean    bool $not    Return Value   $this         Builder|Builder
    orWhereBetween(string $column, array $values)
            Add an or where between statement to the query.   Parameters   string $column    array $values    Return Value   
Builder|Builder
         Builder|Builder
    whereNotBetween(string $column, array $values, string $boolean = 'and')
            Add a where not between statement to the query.   Parameters   string $column    array $values    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereNotBetween(string $column, array $values)
            Add an or where not between statement to the query.   Parameters   string $column    array $values    Return Value   
Builder|Builder
         Builder|Builder
    orWhereNotNull(string $column)
            Add an "or where not null" clause to the query.   Parameters   string $column    Return Value   
Builder|Builder
         Builder|Builder
    whereDate(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')
            Add a "where date" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereDate(string $column, string $operator, DateTimeInterface|string|null $value = null)
            Add an "or where date" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    Return Value   
Builder|Builder
         Builder|Builder
    whereTime(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')
            Add a "where time" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereTime(string $column, string $operator, DateTimeInterface|string|null $value = null)
            Add an "or where time" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    Return Value   
Builder|Builder
         Builder|Builder
    whereDay(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')
            Add a "where day" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereDay(string $column, string $operator, DateTimeInterface|string|null $value = null)
            Add an "or where day" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    Return Value   
Builder|Builder
         Builder|Builder
    whereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')
            Add a "where month" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null)
            Add an "or where month" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|null $value    Return Value   
Builder|Builder
         Builder|Builder
    whereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null, string $boolean = 'and')
            Add a "where year" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|int|null $value    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null)
            Add an "or where year" statement to the query.   Parameters   string $column    string $operator    
DateTimeInterface|string|int|null $value    Return Value   
Builder|Builder
                      protected        $this
    addDateBasedWhere(string $type, string $column, string $operator, mixed $value, string $boolean = 'and')
            Add a date based (year, month, day, time) statement to the query.   Parameters   string $type    string $column    string $operator    mixed $value    string $boolean    Return Value   $this         Builder|Builder
    whereNested(Closure $callback, string $boolean = 'and')
            Add a nested where statement to the query.   Parameters   Closure $callback    string $boolean    Return Value   
Builder|Builder
         Builder
    forNestedWhere()
            Create a new query instance for nested where condition.   Return Value   Builder                              $this
    addNestedWhereQuery(Builder|Builder $query, string $boolean = 'and')
            Add another query builder as a nested where to the query builder.   Parameters   
Builder|Builder
 $query    string $boolean    Return Value   $this                      protected        $this
    whereSub(string $column, string $operator, Closure $callback, string $boolean)
            Add a full sub-select to the query.   Parameters   string $column    string $operator    Closure $callback    string $boolean    Return Value   $this                              $this
    whereExists(Closure $callback, string $boolean = 'and', bool $not = false)
            Add an exists clause to the query.   Parameters   Closure $callback    string $boolean    bool $not    Return Value   $this         Builder|Builder
    orWhereExists(Closure $callback, bool $not = false)
            Add an or exists clause to the query.   Parameters   Closure $callback    bool $not    Return Value   
Builder|Builder
         Builder|Builder
    whereNotExists(Closure $callback, string $boolean = 'and')
            Add a where not exists clause to the query.   Parameters   Closure $callback    string $boolean    Return Value   
Builder|Builder
         Builder|Builder
    orWhereNotExists(Closure $callback)
            Add a where not exists clause to the query.   Parameters   Closure $callback    Return Value   
Builder|Builder
                              $this
    addWhereExistsQuery(Builder $query, string $boolean = 'and', bool $not = false)
            Add an exists clause to the query.   Parameters   Builder $query    string $boolean    bool $not    Return Value   $this                              $this
    whereRowValues(array $columns, string $operator, array $values, string $boolean = 'and')
            Adds a where condition using row values.   Parameters   array $columns    string $operator    array $values    string $boolean    Return Value   $this    Exceptions   InvalidArgumentException                              $this
    orWhereRowValues(array $columns, string $operator, array $values)
            Adds a or where condition using row values.   Parameters   array $columns    string $operator    array $values    Return Value   $this                              $this
    whereJsonContains(string $column, mixed $value, string $boolean = 'and', bool $not = false)
            Add a "where JSON contains" clause to the query.   Parameters   string $column    mixed $value    string $boolean    bool $not    Return Value   $this                              $this
    orWhereJsonContains(string $column, mixed $value)
            Add a "or where JSON contains" clause to the query.   Parameters   string $column    mixed $value    Return Value   $this                              $this
    whereJsonDoesntContain(string $column, mixed $value, string $boolean = 'and')
            Add a "where JSON not contains" clause to the query.   Parameters   string $column    mixed $value    string $boolean    Return Value   $this                              $this
    orWhereJsonDoesntContain(string $column, mixed $value)
            Add a "or where JSON not contains" clause to the query.   Parameters   string $column    mixed $value    Return Value   $this                              $this
    whereJsonLength(string $column, mixed $operator, mixed $value = null, string $boolean = 'and')
            Add a "where JSON length" clause to the query.   Parameters   string $column    mixed $operator    mixed $value    string $boolean    Return Value   $this                              $this
    orWhereJsonLength(string $column, mixed $operator, mixed $value = null)
            Add a "or where JSON length" clause to the query.   Parameters   string $column    mixed $operator    mixed $value    Return Value   $this                              $this
    dynamicWhere(string $method, array $parameters)
            Handles dynamic "where" clauses to the query.   Parameters   string $method    array $parameters    Return Value   $this                      protected        void
    addDynamic(string $segment, string $connector, array $parameters, int $index)
            Add a single dynamic where clause statement to the query.   Parameters   string $segment    string $connector    array $parameters    int $index    Return Value   void                              $this
    groupBy(array|string ...$groups)
            Add a "group by" clause to the query.   Parameters   array|string ...$groups    Return Value   $this                              $this
    groupByRaw(string $sql, array $bindings = [])
            Add a raw groupBy clause to the query.   Parameters   string $sql    array $bindings    Return Value   $this                              $this
    having(string $column, string|null $operator = null, string|null $value = null, string $boolean = 'and')
            Add a "having" clause to the query.   Parameters   string $column    string|null $operator    string|null $value    string $boolean    Return Value   $this         Builder|Builder
    orHaving(string $column, string|null $operator = null, string|null $value = null)
            Add a "or having" clause to the query.   Parameters   string $column    string|null $operator    string|null $value    Return Value   
Builder|Builder
         Builder|Builder
    havingBetween(string $column, array $values, string $boolean = 'and', bool $not = false)
            Add a "having between " clause to the query.   Parameters   string $column    array $values    string $boolean    bool $not    Return Value   
Builder|Builder
                              $this
    havingRaw(string $sql, array $bindings = [], string $boolean = 'and')
            Add a raw having clause to the query.   Parameters   string $sql    array $bindings    string $boolean    Return Value   $this         Builder|Builder
    orHavingRaw(string $sql, array $bindings = [])
            Add a raw or having clause to the query.   Parameters   string $sql    array $bindings    Return Value   
Builder|Builder
                              $this
    orderBy(Closure|Builder|Expression|string $column, string $direction = 'asc')
            Add an "order by" clause to the query.   Parameters   
Closure|Builder|Expression|string $column    string $direction    Return Value   $this    Exceptions   InvalidArgumentException                              $this
    orderByDesc(string $column)
            Add a descending "order by" clause to the query.   Parameters   string $column    Return Value   $this         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
    oldest(string $column = 'created_at')
            Add an "order by" clause for a timestamp to the query.   Parameters   string $column    Return Value   
Builder|Builder
                              $this
    inRandomOrder(string $seed = '')
            Put the query's results in random order.   Parameters   string $seed    Return Value   $this                              $this
    orderByRaw(string $sql, array $bindings = [])
            Add a raw "order by" clause to the query.   Parameters   string $sql    array $bindings    Return Value   $this         Builder|Builder
    skip(int $value)
            Alias to set the "offset" value of the query.   Parameters   int $value    Return Value   
Builder|Builder
                              $this
    offset(int $value)
            Set the "offset" value of the query.   Parameters   int $value    Return Value   $this         Builder|Builder
    take(int $value)
            Alias to set the "limit" value of the query.   Parameters   int $value    Return Value   
Builder|Builder
                              $this
    limit(int $value)
            Set the "limit" value of the query.   Parameters   int $value    Return Value   $this         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|Builder
    forPageBeforeId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')
            Constrain the query to the previous "page" of results before a given ID.   Parameters   int $perPage    int|null $lastId    string $column    Return Value   
Builder|Builder
         Builder|Builder
    forPageAfterId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')
            Constrain the query to the next "page" of results after a given ID.   Parameters   int $perPage    int|null $lastId    string $column    Return Value   
Builder|Builder
                      protected        array
    removeExistingOrdersFor(string $column)
            Get an array with all orders with a given column removed.   Parameters   string $column    Return Value   array         Builder|Builder
    union(Builder|Closure $query, bool $all = false)
            Add a union statement to the query.   Parameters   
Builder|Closure
 $query    bool $all    Return Value   
Builder|Builder
         Builder|Builder
    unionAll(Builder|Closure $query)
            Add a union all statement to the query.   Parameters   
Builder|Closure
 $query    Return Value   
Builder|Builder
                              $this
    lock(string|bool $value = true)
            Lock the selected rows in the table.   Parameters   string|bool $value    Return Value   $this         Builder
    lockForUpdate()
            Lock the selected rows in the table for updating.   Return Value   Builder         Builder
    sharedLock()
            Share lock the selected rows in the table.   Return Value   Builder                              string
    toSql()
            Get the SQL representation of the query.   Return Value   string                              mixed|Builder
    find(int|string $id, array $columns = ['*'])
            Execute a query for a single record by ID.   Parameters   int|string $id    array $columns    Return Value   mixed|Builder
                              mixed
    value(string $column)
            Get a single column's value from the first result of a query.   Parameters   string $column    Return Value   mixed         Collection
    get(array|string $columns = ['*'])
            Execute the query as a "select" statement.   Parameters   array|string $columns    Return Value   Collection                      protected        array
    runSelect()
            Run the query as a "select" statement against the connection.   Return Value   array         LengthAwarePaginator
    paginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)
            Paginate the given query into a simple paginator.   Parameters   int $perPage    array $columns    string $pageName    int|null $page    Return Value   LengthAwarePaginator         Paginator
    simplePaginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)
            Get a paginator only supporting simple next and previous links. This is more efficient on larger data-sets, etc.   Parameters   int $perPage    array $columns    string $pageName    int|null $page    Return Value   Paginator                              int
    getCountForPagination(array $columns = ['*'])
            Get the count of the total records for the paginator.   Parameters   array $columns    Return Value   int                      protected        array
    runPaginationCountQuery(array $columns = ['*'])
            Run a pagination count query.   Parameters   array $columns    Return Value   array                      protected        array
    withoutSelectAliases(array $columns)
            Remove the column aliases since they will break count queries.   Parameters   array $columns    Return Value   array         LazyCollection
    cursor()
            Get a lazy collection for the given query.   Return Value   LazyCollection                      protected        void
    enforceOrderBy()
            Throw an exception if the query doesn't have an orderBy clause.   Return Value   void    Exceptions   RuntimeException         Collection
    pluck(string $column, string|null $key = null)
            Get an array with the values of a given column.   Parameters   string $column    string|null $key    Return Value   Collection                      protected        string|null
    stripTableForPluck(string $column)
            Strip off the table name or alias from a column identifier.   Parameters   string $column    Return Value   string|null                      protected        Collection
    pluckFromObjectColumn(array $queryResult, string $column, string $key)
            Retrieve column values from rows represented as objects.   Parameters   array $queryResult    string $column    string $key    Return Value   Collection                      protected        Collection
    pluckFromArrayColumn(array $queryResult, string $column, string $key)
            Retrieve column values from rows represented as arrays.   Parameters   array $queryResult    string $column    string $key    Return Value   Collection                              string
    implode(string $column, string $glue = '')
            Concatenate values of a given column as a string.   Parameters   string $column    string $glue    Return Value   string                              bool
    exists()
            Determine if any rows exist for the current query.   Return Value   bool                              bool
    doesntExist()
            Determine if no rows exist for the current query.   Return Value   bool                              mixed
    existsOr(Closure $callback)
            Execute the given callback if no rows exist for the current query.   Parameters   Closure $callback    Return Value   mixed                              mixed
    doesntExistOr(Closure $callback)
            Execute the given callback if rows exist for the current query.   Parameters   Closure $callback    Return Value   mixed                              int
    count(string $columns = '*')
            Retrieve the "count" result of the query.   Parameters   string $columns    Return Value   int                              mixed
    min(string $column)
            Retrieve the minimum value of a given column.   Parameters   string $column    Return Value   mixed                              mixed
    max(string $column)
            Retrieve the maximum value of a given column.   Parameters   string $column    Return Value   mixed                              mixed
    sum(string $column)
            Retrieve the sum of the values of a given column.   Parameters   string $column    Return Value   mixed                              mixed
    avg(string $column)
            Retrieve the average of the values of a given column.   Parameters   string $column    Return Value   mixed                              mixed
    average(string $column)
            Alias for the "avg" method.   Parameters   string $column    Return Value   mixed                              mixed
    aggregate(string $function, array $columns = ['*'])
            Execute an aggregate function on the database.   Parameters   string $function    array $columns    Return Value   mixed                              float|int
    numericAggregate(string $function, array $columns = ['*'])
            Execute a numeric aggregate function on the database.   Parameters   string $function    array $columns    Return Value   float|int                      protected        $this
    setAggregate(string $function, array $columns)
            Set the aggregate property without running the query.   Parameters   string $function    array $columns    Return Value   $this                      protected        mixed
    onceWithColumns(array $columns, callable $callback)
            Execute the given callback while selecting the given columns. After running the callback, the columns are reset to the original value.   Parameters   array $columns    callable $callback    Return Value   mixed                              bool
    insert(array $values)
            Insert a new record into the database.   Parameters   array $values    Return Value   bool                              int
    insertOrIgnore(array $values)
            Insert a new record into the database while ignoring errors.   Parameters   array $values    Return Value   int                              int
    insertGetId(array $values, string|null $sequence = null)
            Insert a new record and get the value of the primary key.   Parameters   array $values    string|null $sequence    Return Value   int                              int
    insertUsing(array $columns, Closure|Builder|string $query)
            Insert new records into the table using a subquery.   Parameters   array $columns    
Closure|Builder|string $query    Return Value   int                              int
    update(array $values)
            Update a record in the database.   Parameters   array $values    Return Value   int                              bool
    updateOrInsert(array $attributes, array $values = [])
            Insert or update a record matching the attributes, and fill it with values.   Parameters   array $attributes    array $values    Return Value   bool                              int
    increment(string $column, float|int $amount = 1, array $extra = [])
            Increment a column's value by a given amount.   Parameters   string $column    float|int $amount    array $extra    Return Value   int    Exceptions   InvalidArgumentException                              int
    decrement(string $column, float|int $amount = 1, array $extra = [])
            Decrement a column's value by a given amount.   Parameters   string $column    float|int $amount    array $extra    Return Value   int    Exceptions   InvalidArgumentException                              int
    delete(mixed $id = null)
            Delete a record from the database.   Parameters   mixed $id    Return Value   int                              void
    truncate()
            Run a truncate statement on the table.   Return Value   void         Builder
    newQuery()
            Get a new instance of the query builder.   Return Value   Builder                      protected        Builder
    forSubQuery()
            Create a new query instance for a sub-query.   Return Value   Builder         Expression
    raw(mixed $value)
            Create a raw database expression.   Parameters   mixed $value    Return Value   Expression                              array
    getBindings()
            Get the current query value bindings in a flattened array.   Return Value   array                              array
    getRawBindings()
            Get the raw array of bindings.   Return Value   array                              $this
    setBindings(array $bindings, string $type = 'where')
            Set the bindings on the query builder.   Parameters   array $bindings    string $type    Return Value   $this    Exceptions   InvalidArgumentException                              $this
    addBinding(mixed $value, string $type = 'where')
            Add a binding to the query.   Parameters   mixed $value    string $type    Return Value   $this    Exceptions   InvalidArgumentException                              $this
    mergeBindings(Builder $query)
            Merge an array of bindings into our bindings.   Parameters   Builder $query    Return Value   $this                      protected        array
    cleanBindings(array $bindings)
            Remove all of the expressions from a list of bindings.   Parameters   array $bindings    Return Value   array                      protected        string
    defaultKeyName()
            Get the default key name of the table.   Return Value   string         ConnectionInterface
    getConnection()
            Get the database connection instance.   Return Value   ConnectionInterface         Processor
    getProcessor()
            Get the database query processor instance.   Return Value   Processor         Grammar
    getGrammar()
            Get the query grammar instance.   Return Value   Grammar                              $this
    useWritePdo()
            Use the write pdo for query.   Return Value   $this                      protected        bool
    isQueryable(mixed $value)
            Determine if the value is a query builder instance or a Closure.   Parameters   mixed $value    Return Value   bool         Builder
    cloneWithout(array $properties)
            Clone the query without the given properties.   Parameters   array $properties    Return Value   Builder         Builder
    cloneWithoutBindings(array $except)
            Clone the query without the given bindings.   Parameters   array $except    Return Value   Builder                              $this
    dump()
            Dump the current SQL and bindings.   Return Value   $this                              void
    dd()
            Die and dump the current SQL and bindings.   Return Value   void      

    
{'path': 'public/docs/laravel~6/api/6.x/illuminate/database/query/builder.html', 'source': 'DevDocs.IO'}