mini\Parsing\SQL\SqlRenderer class

Documentation

Renders AST nodes back to SQL strings

This is the inverse of SqlParser - it takes an AST and produces SQL. Used by PartialQuery to generate SQL from its internal AST representation.

Usage:

$renderer = SqlRenderer::forDialect(SqlDialect::MySQL);
$sql = $renderer->render($ast);

// Or with params collection (for prepared statements):
[$sql, $params] = $renderer->renderWithParams($ast);

Properties (2)

private mini\Database\SqlDialect $dialect
private ?array $collectingParams

Collected params during renderWithParams()

Methods (34)

private __construct()

Documentation missing

public static forDialect()

Create a renderer for a specific SQL dialect

public render()

Render an AST node to SQL string

public renderWithParams()

Render an AST node to SQL string and collect bound parameter values

public renderOrderByItems()

Render ORDER BY items to SQL string (without ORDER BY keywords)

private doRender()

Documentation missing

private renderWith()

Documentation missing

private renderSelect()

Documentation missing

private renderLimitOffset()

Render LIMIT/OFFSET clause based on dialect

private renderUnion()

Documentation missing

private renderSubquery()

Documentation missing

private renderColumn()

Documentation missing

private renderJoin()

Documentation missing

private renderIdentifier()

Documentation missing

private renderLiteral()

Documentation missing

private renderPlaceholder()

Documentation missing

private renderBinary()

Documentation missing

private renderUnary()

Documentation missing

private renderIn()

Documentation missing

private renderIsNull()

Documentation missing

private renderLike()

Documentation missing

private renderBetween()

Documentation missing

private renderExists()

Documentation missing

private renderFunction()

Documentation missing

private renderCase()

Documentation missing

private renderWindow()

Documentation missing

private renderQuantified()

Documentation missing

public renameIdentifier()

Rename an identifier throughout an AST

private renameInWith()

Documentation missing

private renameInSelect()

Documentation missing

private renameInJoin()

Documentation missing

private renameInIn()

Documentation missing

private renameInCase()

Documentation missing

private renameInWindow()

Documentation missing

Source

src/Parsing/SQL/SqlRenderer.php:46-768