Open
Description
Bug report
- I confirm this is a bug with Supabase, not with my own application.
- I confirm I have searched the Docs, GitHub Discussions, and Discord.
Describe the bug
Query builder objects are not immutable, which means that you cannot share a query builder and add separate conditions on each execution.
query = (
sb.table("items")
.select("*")
.eq("account_id", "abc")
)
query.in_("id", ["1", "2", "3"]).execute()
query.in_("id", ["4", "5", "6"]).execute()
This will execute one query with ids = 1, 2, 3
and then the second query will be 1, 2, 3, 4, 5, 6
.
Expected behavior
One query with ids = 1, 2, 3
and another with 4, 5, 6
.
Discord Discussion
https://discord.com/channels/839993398554656828/1319331194902413384