mini\Database\PartialQuery::fromSql()
Method
public
static
Signature
public static function fromSql(mini\Database\DatabaseInterface $db, Closure $executor, string $sql, array $params = array (
)): selfParameters
| Name | Type | Default | Description |
|---|---|---|---|
$db |
mini\Database\DatabaseInterface |
required | Documentation missing |
$executor |
Closure |
required | Documentation missing |
$sql |
string |
required | Documentation missing |
$params |
array |
array (
)
|
Documentation missing |
Returns
self
Documentation
Create a PartialQuery from SQL
The executor closure handles raw query execution for iteration.
Note: SQL with WHERE/ORDER BY/LIMIT acts as a "barrier" - subsequent
operations filter/sort WITHIN those results, not before them. This is
intentional: query('SELECT * FROM t LIMIT 10')->order('id DESC')
reorders those 10 rows, it doesn't fetch different rows.
For composable queries where filters/sorts apply before limits, use
method chaining: query('SELECT * FROM t')->order('id DESC')->limit(10)