Class Salient\Db\SqlQuery

`final`
`implements`	`Chainable, Readable`
`uses`	`ChainableTrait, ReadableTrait`

A simple representation of a SQL query

Located at Toolkit/Db/SqlQuery.php

Methods


					
	public
					static

getReadableProperties(): array

Get readable properties

Returning ["*"] has the same effect as returning every protected property of the class.


					
	public

__construct(callable(string): string $paramCallback)

$paramCallback

Applied to the name of each parameter added to the query.


					
	public

addParam(string $name, mixed $value, ?string &$placeholder): $this

Add a parameter and assign its query placeholder to a variable


					
	public

where((callable(): (string|mixed[]))|string|mixed[] $condition): $this

Add a WHERE condition


					
	public

whereValueInList(string $name, mixed ...$value): $this

Add a list of values as a WHERE condition ("<name> IN (<value>...)") unless the list is empty

Add a list of values as a WHERE condition (" IN (...)") unless the list is empty


					
	public

getWhere(array<string, mixed>|null &$values = null): ?string

Prepare a WHERE condition for use in a SQL statement

Methods used from Salient\Core\Concern\ChainableTrait
`apply(), applyIf(), applyForEach()`

Constants
`public`	`AND = 'AND'`	#
`public`	`OR = 'OR'`	#

Properties
`public`	`array<string\|mixed[]>`	`$Where = []`	#
`public readonly`	`array<string, mixed>`	`$Values` Parameter name => value Parameter name => value	#
`protected`	`callable(string): string`	`$ParamCallback`	#