API: QueryBuilder

Class: Infocyph\DBLayer\Query\QueryBuilder

QueryBuilder is mutable and chainable. Compose clauses first, then execute with get(), first(), update(), delete(), and related methods. Use cloneBuilder() or newQuery() when branching logic needs isolation.

For API selection guidance, see choosing-api and api-table-repository.

Select/Read

• table(), from(), fromSub()

• select(), addSelect(), selectRaw(), selectWindow()

• get(), first(), find(), firstWhere(), exists()

• value(), pluck(), count(), min(), max(), avg(), sum(), aggregate()

Filters

• where(), orWhere()

• whereIn(), whereNotIn()

• whereBetween(), whereNotBetween()

• whereNull(), whereNotNull()

• whereRaw(), whereExists(), whereNested()

Join and Set Operations

• join(), leftJoin(), rightJoin(), crossJoin(), joinComplex()

• union(), unionAll()

CTE

• with()

• withRecursive()

Writes

• insert(), insertGetId(), insertIgnore(), insertReturning()

• update(), delete(), truncate()

• upsert(), upsertReturning()

Pagination/Streaming

• paginate(), simplePaginate(), cursorPaginate()

• chunk(), chunkById(), cursor()

Other

• lockForUpdate(), sharedLock()

• when(), unless()

• toSql(), toSelectSql(), toPayload()

• getBindings(), getComponents()