how to get all items from a table where a column is null.

supabase.table('vehicles').select('id').is('deleted', None).execute()

python library does not seem to support the

.is

like in subabase-js

It does, but it is a bit hacky. Please try

.is_("deleted","NULL").execute()

right, there is a good first issue in postgrest-py, it's a one line change, which would allow us to use python values like None instead of having to write json values as strings like "NULL"

The python client is maintained by the community but I agree with your point. Perhaps I'll make this my first commit to the client. 🙂

Nice!