Remember the Supabase query builder is immutable | BeforeMerge Rules | BeforeMerge

Remember the Supabase query builder is immutable | BeforeMerge Rules | BeforeMerge

Why This Matters

The query builder is immutable — each method returns a new object.

Good

let query = supabase.from("scans").select("*")
query = query.eq("status", "active")  // reassign!
query = query.order("created_at", { ascending: false })
const { data } = await query

Bad

let query = supabase.from("scans").select("*")
query.eq("status", "active")  // DOES NOTHING — return value discarded!
const { data } = await query   // returns ALL scans, not just active