`mini\Database\PartialQuery` final class

Show private and protected members

Documentation

Immutable query builder for composable SQL queries

Inheritance

Implements: mini\Database\ResultSetInterface mini\Table\Contracts\MutableTableInterface Stringable Traversable Countable JsonSerializable IteratorAggregate mini\Table\Contracts\SetInterface mini\Table\Contracts\TableInterface

Uses Traits: mini\Table\Utility\TablePropertiesTrait

Properties (14)

private mini\Database\DatabaseInterface $db

private Closure $executor

private string $baseSql

Original SQL string - used directly for fast path when AST is null

private array $originalParams

Original params - used directly for fast path when AST is null

private ?mini\Parsing\SQL\AST\ASTNode $ast

Single AST root - the source of truth for query structure

private bool $astIsPrivate

Whether this instance owns its AST (for copy-on-write)

private bool $selectCalled

Track if select/columns was called (for has() validation)

private ?array $availableColumns

Available columns after explicit projection (null = unrestricted)

private ?Closure $hydrator

private ?string $entityClass

private array|false $entityConstructorArgs

private ?Closure $loadCallback

private ?array $columnCache

private array $props

Methods (88)

private `__construct()`

Documentation missing

private `ensureAST()`

Ensure AST exists (lazy parsing)

private `bindParamsToAST()`

Bind parameter values to PlaceholderNodes in an AST

private `ensureMutableAST()`

Ensure AST is mutable (copy-on-write)

private `getModifiableSelect()`

Get the innermost SelectStatement for modification

private `wrapInSelect()`

Wrap an AST node in a SELECT * FROM (...) AS alias

public `__clone()`

Clone handler - mark AST as shared for copy-on-write

private `borrowAstForEmbedding()`

Borrow AST for embedding into another query

public `getAST()`

Get the AST representation of this query

public `getSql()`

Get SQL and parameters for execution

public static `fromSql()`

Create a PartialQuery from SQL

public static `fromTable()`

Create a PartialQuery from any TableInterface

private `getSourceTableInfo()`

Get source table info from AST (computed on demand)

public `isSingleTable()`

Check if this is a single-table query (supports UPDATE/DELETE)

public `getSourceTable()`

Get the underlying source table for UPDATE/DELETE operations

public `withEntityClass()`

Use an entity class for hydration

public `withLoadCallback()`

Set a callback to be called after each entity is hydrated

public `withHydrator()`

Use a custom hydrator closure

public `where()`

Add a WHERE clause with raw SQL

private `andPredicate()`

AND a predicate to the WHERE clause (internal helper)

private `matchNone()`

Return a query that matches no rows (WHERE 1=0)

private `columnNode()`

Create column identifier from name (handles table.column)

private `boundPlaceholder()`

Create a placeholder with value pre-bound

public `eq()`

Add WHERE column = value clause (NULL -> IS NULL)

public `lt()`

Documentation missing

public `lte()`

Documentation missing

public `gt()`

Documentation missing

public `gte()`

Documentation missing

public `in()`

Add WHERE column IN (...) clause

public `like()`

Add WHERE column LIKE pattern clause

public `union()`

Union with another query (OR semantics, deduplicated)

public `except()`

Difference from another query (NOT IN semantics)

private `mergeCTEsFrom()`

Merge CTEs from another query into this one

private `getInnerQuery()`

Get the inner query (without CTE wrapper)

private `findCTEIndex()`

Find a CTE by name in the AST

private `ensureWithStatement()`

Ensure AST is wrapped in a WithStatement (for adding CTEs)

public `withCTE()`

Add a PartialQuery as a named CTE (Common Table Expression)

public `select()`

Set SELECT clause (wraps query with new projection)

private `selectInternal()`

Internal: wrap query with new SELECT clause

private `extractColumnRefs()`

Extract column references from an expression AST

private `getColumnOutputName()`

Get the output name of a column node

public `columns()`

Project to specific columns (TableInterface method)

public `has()`

Check if value(s) exist in the table (SetInterface method)

public `order()`

Set ORDER BY clause (overwrites previous)

public `limit()`

Set LIMIT (can only narrow, never expand)

public `offset()`

Set OFFSET (additive, stays within window)

protected `barrier()`

Create a barrier - wrap current query as subquery (internal)

public `distinct()`

Return distinct rows only

public `withAlias()`

Alias this table/query

private `getSelectForReading()`

Get SelectStatement for reading (without triggering copy-on-write)

private `hasPagination()`

Check if query has pagination (LIMIT or OFFSET)

public `one()`

Fetch first row or null

public `column()`

Fetch first column from all rows

public `field()`

Fetch first column of first row

public `toArray()`

Get all rows as array

public `jsonSerialize()`

JSON serialize - returns all rows

public `map()`

Transform each row using a closure

public `filter()`

Filter rows using a closure

public `count()`

Count rows that would be returned by iteration

private `stripOrderBy()`

Strip ORDER BY from an AST (mutates)

public `getIterator()`

Iterator over results (streaming)

public `getWhere()`

Get WHERE clause SQL and parameters, for DELETE/UPDATE

public `matches()`

Test if a row matches the query's WHERE conditions

public `getLimit()`

Get LIMIT value (for DELETE/UPDATE implementations)

public `getOffset()`

Get current offset

public `exists()`

Check if any rows exist

public `getColumns()`

Get column definitions

public `getAllColumns()`

Get all column definitions (including hidden columns)

private `fetchColumnDefinitions()`

Fetch column definitions from schema or AST

private `fetchSchemaColumns()`

Fetch column definitions from database schema

private `extractColumnsFromAST()`

Extract column definitions from explicit SELECT list

private `mapSqlTypeToColumnType()`

Map SQL data type string to ColumnType

public `or()`

OR predicate support

private `predicateToAst()`

Convert a Predicate to AST expression

private `conditionToAst()`

Convert a single condition to AST

private `valueToLiteral()`

Convert a PHP value to a LiteralNode

private `createBoundPlaceholder()`

Create a bound placeholder (named parameter that's already resolved)

public `load()`

Load a single row by ID

public `getCTEs()`

Get CTE (Common Table Expression) prefix for DELETE/UPDATE

public `__debugInfo()`

Debug information for var_dump/print_r

public `__toString()`

Convert to string for logging/debugging

public `insert()`

Insert a new row into the underlying table

public `update()`

Update rows matching this query

public `delete()`

Delete rows matching this query

private `combineWithFilter()`

Combine this query's constraints with a filter query

public `getProperty()`

Get a property value

public `hasProperty()`

Check if a property exists (including null values)

public `withProperty()`

Return table with property set

Source

src/Database/PartialQuery.php:45-2296

mini\Database\PartialQuery final class

Documentation

Inheritance

Properties (14)

Methods (88)

Source

`mini\Database\PartialQuery` final class