support CTE

Summarize the changes

• feat(sql): implement CTEs

Depends on !427 (merged)

Ensure that

• New code is covered by unit and integration tests.
• Related issues would be automatically closed with gitlab's closing pattern (Closes #1, #2).
• Public modules are documented (check the rendered version with cargo doc --open).
• (if PEST grammar is changed) EBNF grammar reflects these changes (check the result with railroad diagram generator.

Next steps

• Update sbroad submodule in picodata/picodata.
• (if EBNF grammar is changed) create a follow-up issue in picodata/docs.

added SQL in-progress + 1 deleted label

assigned to @darthunix

added 2 commits

• 37d12450 - 1 commit from branch main
• 0c02accb - feat(sql): implement CTEs

Compare with previous version

added 1 commit

• f6741c67 - feat(sql): implement CTEs

Compare with previous version

marked the checklist item (if PEST grammar is changed) EBNF grammar reflects these changes as completed

added 2 commits

• 84446ce6 - 1 commit from branch main
• 4aa2ffaf - feat(sql): implement CTEs

Compare with previous version

marked this merge request as ready

requested review from @EmirVildanov

added 1 commit

• 2e9a496d - feat(sql): implement CTEs

Compare with previous version

changed the description

mentioned in merge request picodata!965 (merged)

mentioned in merge request !418 (merged)

added 2 commits

• 0c57585a - 1 commit from branch main
• 93bbd69f - feat(sql): implement CTEs

Compare with previous version

added 1 commit

• a8a92218 - feat(sql): implement CTEs

Compare with previous version

requested review from @senya_volynets and removed review request for @EmirVildanov