Skip to content

Remove separate WithQuery to ensure it can be specified everywhere#814

Closed
bouk wants to merge 1 commit intoSeaQL:masterfrom
bouk:bouk/unify-with
Closed

Remove separate WithQuery to ensure it can be specified everywhere#814
bouk wants to merge 1 commit intoSeaQL:masterfrom
bouk:bouk/unify-with

Conversation

@bouk
Copy link
Copy Markdown

@bouk bouk commented Sep 6, 2024

Instead, move the with clause into insert/update/select/delete. This makes sure you can specify with WITH clause to any method that takes a SelectStatement/UpdateStatement/InsertStatement/DeleteStatement.

PR Info

Breaking Changes

  • This removes WithQuery and changes the signature of .with()

Instead, move the with clause into insert/update/select/delete.

Fixes SeaQL#813
@tyt2y3
Copy link
Copy Markdown
Member

tyt2y3 commented Oct 1, 2024

Thank you for your contribution. While I appreciate now that we can use a with clause in all statement types, removing WithQuery is breaking. Is there a middleground where we still keep it?

@bouk
Copy link
Copy Markdown
Author

bouk commented Oct 8, 2024

We could keep both kinds and deprecate WithQuery, removing it in a later version.

@rumpuslabs
Copy link
Copy Markdown
Contributor

@tyt2y3 @bouk see #859 which implements the suggested approach

@tyt2y3
Copy link
Copy Markdown
Member

tyt2y3 commented Feb 16, 2025

Closed in favour of #859

@tyt2y3 tyt2y3 closed this Feb 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Unify SelectStatement and WithQuery

3 participants