classQuerySpecificationWithSelectSymSelectOptionsSelectItemListIntoClauseOptFromClauseOptWhereClauseOp_64027ed6

final class QuerySpecificationWithSelectSymSelectOptionsSelectItemListIntoClauseOptFromClauseOptWhereClauseOp_64027ed6
    implements QueryExpressionBodyForm, QueryPrimaryForm, QuerySpecificationForm, SubselectForm
    uses Assertion
Public API: explicitly declared with @visibility public.

The query_specification SQL value; generated by bin/build-models.php.

Accept a structured SQL valuedoctest
$write = static fn (\SqlSemantics\Statement\Model\MySql\Value\QuerySpecificationWithSelectSymSelectOptionsSelectItemListIntoClauseOptFromClauseOptWhereClauseOp_64027ed6 $value): string => \SqlSemantics\Statement\Writer::render($value);
    $write instanceof \Closure // => true

Properties§

public SelectItemListForm $projections
public IntoClauseForm $intoClause
public OptGroupClauseForm $optGroupClause
public OptHavingClauseForm $optHavingClause
public OptWindowClauseForm $optWindowClause
public OptQualifyClauseForm $optQualifyClause
public Comments $comments = new \SqlSemantics\Statement\Comments()

Methods§

public function __construct(
    public SelectOptionsForm $options,
    public SelectItemListForm $projections,
    public IntoClauseForm $intoClause,
    public OptFromClauseForm $from,
    public OptWhereClauseForm $where,
    public OptGroupClauseForm $optGroupClause,
    public OptHavingClauseForm $optHavingClause,
    public OptWindowClauseForm $optWindowClause,
    public OptQualifyClauseForm $optQualifyClause,
    public Comments $comments = new \SqlSemantics\Statement\Comments(),
)

Supplies the SQL values of this form; comments are kept by the position of the symbol each precedes.

Parameters

$optionsSelectOptionsForm
$projectionsSelectItemListForm
$intoClauseIntoClauseForm
$fromOptFromClauseForm
$whereOptWhereClauseForm
$optGroupClauseOptGroupClauseForm
$optHavingClauseOptHavingClauseForm
$optWindowClauseOptWindowClauseForm
$optQualifyClauseOptQualifyClauseForm
$commentsComments
Calls 3
public function write(Writer $writer): void
public function withOptions(SelectOptionsForm $options): self

Returns a copy with a new options, preserving every other field.

Parameters

Returns

self
Calls 1
public function withProjections(SelectItemListForm $projections): self

Returns a copy with a new projections, preserving every other field.

Parameters

$projectionsSelectItemListForm

Returns

self
Calls 1
public function withIntoClause(IntoClauseForm $intoClause): self

Returns a copy with a new intoClause, preserving every other field.

Parameters

$intoClauseIntoClauseForm

Returns

self
Calls 1
public function withFrom(OptFromClauseForm $from): self

Returns a copy with a new from, preserving every other field.

Parameters

Returns

self
Calls 1
public function withWhere(OptWhereClauseForm $where): self

Returns a copy with a new where, preserving every other field.

Parameters

Returns

self
Calls 1
public function withOptGroupClause(OptGroupClauseForm $optGroupClause): self

Returns a copy with a new optGroupClause, preserving every other field.

Parameters

$optGroupClauseOptGroupClauseForm

Returns

self
Calls 1
public function withOptHavingClause(OptHavingClauseForm $optHavingClause): self

Returns a copy with a new optHavingClause, preserving every other field.

Parameters

$optHavingClauseOptHavingClauseForm

Returns

self
Calls 1
public function withOptWindowClause(OptWindowClauseForm $optWindowClause): self

Returns a copy with a new optWindowClause, preserving every other field.

Parameters

$optWindowClauseOptWindowClauseForm

Returns

self
Calls 1
public function withOptQualifyClause(OptQualifyClauseForm $optQualifyClause): self

Returns a copy with a new optQualifyClause, preserving every other field.

Parameters

$optQualifyClauseOptQualifyClauseForm

Returns

self
Calls 1
public function withComments(Comments $comments): self

Returns a copy with a new comments, preserving every other field.

Parameters

$commentsComments

Returns

self
Calls 1