mini\Parsing\SQL\AST\SubqueryNode class

Documentation

Subquery node - a SELECT statement used as a value expression

Subqueries can appear in various contexts:

• IN clause: WHERE id IN (SELECT user_id FROM orders)
• Scalar comparison: WHERE count = (SELECT MAX(count) FROM stats)
• EXISTS: WHERE EXISTS (SELECT 1 FROM orders WHERE user_id = users.id)

The context determines how the subquery result is interpreted:

• IN: uses all rows from first column
• Scalar: expects exactly one row/column, errors otherwise
• EXISTS: checks if any rows returned

Inheritance

Extends: mini\Parsing\SQL\AST\ASTNode

Implements: JsonSerializable mini\Parsing\SQL\AST\ValueNodeInterface

Properties (2)

Methods (3)

Source

src/Parsing/SQL/AST/SubqueryNode.php:18-27