Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add a query annotation to enable batching across multiple tables #3752

Open
GeorgyBocharov opened this issue Dec 17, 2024 · 0 comments
Open
Labels
📚 postgresql enhancement New feature or request

Comments

@GeorgyBocharov
Copy link

What do you want to change?

Currently, sqlc only supports the :batchexec annotation, which allows for combining multiple inserts into the same table within a single batch. While this is useful, there are situations where you may need to insert data into multiple tables. In such cases, you might want sqlc to simply queue the queries in a batch and return them, enabling you to pass the same batch to another sqlc batch function. This way, you can execute the batch once all queries have been queued.

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Go

@GeorgyBocharov GeorgyBocharov added the enhancement New feature or request label Dec 17, 2024
@GeorgyBocharov GeorgyBocharov changed the title Add :batchqueue query annotation to enable combining inserts into multiple tables into a single batch Add a query annotation to enable batching across multiple tables Dec 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
📚 postgresql enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant