or() expects you to use the raw PostgREST syntax for the filter names and values.
.or(#"id.in.(5,6,7), arraycol.cs.\{"a","b"\}"#) // Use `()` for `in` filter, `\{\}` for array values and `cs` for `contains()`.
.or(#"id.in.(5,6,7), arraycol.cd.\{"a","b"\}"#) // Use `cd` for `containedBy()`
try await supabase.database
.from("countries")
.select("name")
.or("id.eq.2,name.eq.Algeria")
try await supabase.database
.from("countries")
.select("name")
.or("id.gt.3,and(id.eq.1,name.eq.Afghanistan)")