packages/sql-semantics-mysql/resources/models/Value/DerivedTableWithLateralSymTableSubqueryOptTableAliasOptDerivedColumnList_01106007.php

1<?php
2
3declare(strict_types=1);
4
5namespace SqlSemantics\Statement\Model\MySql\Value;
6
7/**
8 * The derived_table SQL value; generated by bin/build-models.php.
9 *
10 * @visibility public
11 * @example Accept a structured SQL value
12 *     $write = static fn (\SqlSemantics\Statement\Model\MySql\Value\DerivedTableWithLateralSymTableSubqueryOptTableAliasOptDerivedColumnList_01106007 $value): string => \SqlSemantics\Statement\Writer::render($value);
13 *     $write instanceof \Closure // => true
14 */
15final class DerivedTableWithLateralSymTableSubqueryOptTableAliasOptDerivedColumnList_01106007 implements \SqlSemantics\Statement\Model\MySql\Role\DerivedTableForm, \SqlSemantics\Statement\Model\MySql\Role\DerivedTableListForm, \SqlSemantics\Statement\Model\MySql\Role\EscTableRefForm, \SqlSemantics\Statement\Model\MySql\Role\EscTableReferenceForm, \SqlSemantics\Statement\Model\MySql\Role\FromTablesForm, \SqlSemantics\Statement\Model\MySql\Role\JoinTableListForm, \SqlSemantics\Statement\Model\MySql\Role\SelectDerivedForm, \SqlSemantics\Statement\Model\MySql\Role\TableFactorForm, \SqlSemantics\Statement\Model\MySql\Role\TableRefForm, \SqlSemantics\Statement\Model\MySql\Role\TableReferenceForm, \SqlSemantics\Statement\Model\MySql\Role\TableReferenceListForm
16{
17    use \SqlSemantics\Statement\Assertion;
18
19    /**
20     * Supplies the SQL values of this form; comments are kept by the position of the symbol each precedes.
21     */
22    public function __construct(
23        public readonly \SqlSemantics\Statement\Model\MySql\Role\TableSubqueryForm $tableSubquery,
24        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptTableAliasForm $optTableAlias,
25        public readonly \SqlSemantics\Statement\Model\MySql\Role\OptDerivedColumnListForm $optDerivedColumnList,
26        public readonly \SqlSemantics\Statement\Comments $comments = new \SqlSemantics\Statement\Comments(),
27    ) {
28        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($tableSubquery), 'The tableSubquery must be a generated immutable SQL value.');
29        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optTableAlias), 'The optTableAlias must be a generated immutable SQL value.');
30        $this->assert(\SqlSemantics\Statement\Model\MySql\Contract\Contracts::contains($optDerivedColumnList), 'The optDerivedColumnList must be a generated immutable SQL value.');
31    }
32
33    /**
34     * Writes SQL entirely from this value's fields.
35     */
36    public function write(\SqlSemantics\Statement\Writer $writer): void
37    {
38        $writer->comments($this->comments, 0);
39        $writer->append('LATERAL');
40        $writer->comments($this->comments, 1);
41        $this->tableSubquery->write($writer);
42        $writer->comments($this->comments, 2);
43        $this->optTableAlias->write($writer);
44        $writer->comments($this->comments, 3);
45        $this->optDerivedColumnList->write($writer);
46    }
47
48    /**
49     * Returns a copy with a new tableSubquery, preserving every other field.
50     */
51    public function withTableSubquery(\SqlSemantics\Statement\Model\MySql\Role\TableSubqueryForm $tableSubquery): self
52    {
53        return new self($tableSubquery, $this->optTableAlias, $this->optDerivedColumnList, $this->comments);
54    }
55
56    /**
57     * Returns a copy with a new optTableAlias, preserving every other field.
58     */
59    public function withOptTableAlias(\SqlSemantics\Statement\Model\MySql\Role\OptTableAliasForm $optTableAlias): self
60    {
61        return new self($this->tableSubquery, $optTableAlias, $this->optDerivedColumnList, $this->comments);
62    }
63
64    /**
65     * Returns a copy with a new optDerivedColumnList, preserving every other field.
66     */
67    public function withOptDerivedColumnList(\SqlSemantics\Statement\Model\MySql\Role\OptDerivedColumnListForm $optDerivedColumnList): self
68    {
69        return new self($this->tableSubquery, $this->optTableAlias, $optDerivedColumnList, $this->comments);
70    }
71
72    /**
73     * Returns a copy with a new comments, preserving every other field.
74     */
75    public function withComments(\SqlSemantics\Statement\Comments $comments): self
76    {
77        return new self($this->tableSubquery, $this->optTableAlias, $this->optDerivedColumnList, $comments);
78    }
79}
80