`mini\Parsing\SQL\SqlParser` class

Show private and protected members

Documentation

SQL Parser - Recursive Descent Implementation

Features:

Generates an AST (Abstract Syntax Tree)
Supports SELECT, INSERT, UPDATE, DELETE
Supports WHERE, ORDER BY, LIMIT
Supports IN (LIST) and IN (SELECT ...) recursively
Supports Function Calls (e.g. COUNT(*), MAX(col))
Supports dotted identifiers (table.column)
Supports Placeholders (? and :name)
Supports Negative Numbers (-5)
Rich Error Reporting (Line numbers + Visual pointers)

Constants (3)

Name	Value
`CACHE_MAX_SIZE`	`256`
`COMPARISON_OPS`	`array ( 0 => '=', 1 => '!=', 2 => '<>', 3 => '<', 4 => '<=', 5 => '>', 6 => '>=', )`
`JOIN_TYPE_TOKENS`	`array ( 0 => 'JOIN', 1 => 'LEFT', 2 => 'RIGHT', 3 => 'INNER', 4 => 'FULL', 5 => 'CROSS', )`

Properties (4)

private string $sql

private array $tokens

private int $pos

private static array $astCache

Methods (56)

public `parse()`

Parse SQL string into AST

public `parseExpressionFragment()`

Parse a SQL expression fragment into AST

public `parseOrderByFragment()`

Parse an ORDER BY clause fragment into AST

private `current()`

Documentation missing

private `peek()`

Documentation missing

private `match()`

Documentation missing

private `expect()`

Documentation missing

private `expectOp()`

Documentation missing

private `parseSelectStatement()`

Documentation missing

private `parseSelectOrUnion()`

Parse a query that may start with WITH or SELECT, and may include UNION/INTERSECT/EXCEPT

private `parseWithBody()`

Parse WITH statement body (CTEs + main query) without EOF validation

private `parseInsertStatement()`

Documentation missing

private `parseReplaceStatement()`

Documentation missing

private `parseInsertBody()`

Documentation missing

private `parseUpdateStatement()`

Documentation missing

private `parseDeleteStatement()`

Documentation missing

private `parseWithStatement()`

Parse WITH statement at top level (with EOF validation)

private `parseCteDefinition()`

Parse a single CTE definition: name [(columns)] AS (query)

private `parseColumnList()`

Documentation missing

private `parseExpression()`

Documentation missing

private `parseAnd()`

Documentation missing

private `parseComparison()`

Documentation missing

private `parseBetweenOperation()`

Documentation missing

private `parseInOperation()`

Documentation missing

private `parseExistsOperation()`

Documentation missing

private `parseDerivedTable()`

Parse a derived table: (SELECT ...) in FROM position

private `parseAdditive()`

Documentation missing

private `parseMultiplicative()`

Documentation missing

private `parseConcatenation()`

Documentation missing

private `parseAtom()`

Documentation missing

private `parseNumberOrPlaceholder()`

Parse a number or placeholder (for LIMIT/OFFSET/FETCH)

private `parseFunctionCall()`

Documentation missing

private `parseWindowSpec()`

Parse OVER (PARTITION BY ... ORDER BY ...) clause

private `parseCaseExpression()`

Parse CASE expression

private `parseIdentifier()`

Documentation missing

private `isJoinStart()`

Documentation missing

private `parseJoin()`

Documentation missing

private `parseJoinType()`

Documentation missing

public static `parseWithParams()`

Parse SQL and bind parameters, returning the AST

public static `parseCached()`

Parse SQL with caching - returns AST from cache (possibly shared)

public static `clearCache()`

Clear the AST cache (for testing or memory management)

private `parseCreateStatement()`

Parse CREATE statement (TABLE, INDEX, VIEW)

private `parseCreateTable()`

Parse CREATE TABLE statement

private `parseColumnDefinition()`

Parse column definition

private `parseColumnConstraint()`

Parse a single column constraint

private `parseDefaultValue()`

Parse default value expression

private `parseTableConstraint()`

Parse table-level constraint

private `parseConstraintColumnList()`

Parse (col1, col2, ...) list for constraints

private `parseReferentialAction()`

Parse referential action (CASCADE, RESTRICT, SET NULL, etc.)

private `parseCreateIndex()`

Parse CREATE INDEX statement

private `parseDropStatement()`

Parse DROP statement (TABLE, INDEX)

private `parseDropTable()`

Parse DROP TABLE statement

private `parseDropIndex()`

Parse DROP INDEX statement

private `expectKeyword()`

Expect a specific keyword (may be token or identifier)

private `expectIdentifierName()`

Expect an identifier token and return its name

public static `bindParams()`

Bind parameter values to PlaceholderNodes in an AST

Source

src/Parsing/SQL/SqlParser.php:50-1877

mini\Parsing\SQL\SqlParser class

Documentation

Constants (3)

Properties (4)

Methods (56)

Source

`mini\Parsing\SQL\SqlParser` class