postgrest-py
postgrest-py copied to clipboard
Implement or filter
Since we have a different way to use the not
operator than postgrest-js does, an idea for the or
filter might be:
supabase_client.table("table")
.select("*")
.or()
.eq("col1", "value1a")
.eq("col1", "value1b")
.end_or
.eq("col2", "value2")
.execute()
The end_or
can be a property, but or
has to be a method since the user should be able pass a foreign_table
as an argument.
Thanks for making the issue, and/or filters are a pretty important feature we haven't yet implemented Although this version feels a little hacky to me; I'd rather we implement another style of queries itself, something like what I had implemented in an old fork of mine
This would also be extremely helpful!
Any plans to implement this soon?
The work on this can be seen in this PR https://github.com/supabase-community/postgrest-py/pull/355
This has now been merged in and available from version 0.14.0 of the Postgrest Python library.