Filter

pawabase.from("tasks")
  .eq("done", false)               // equal
  .neq("owner_id", user.id)        // not equal
  .gt("priority", 2)               // greater than
  .gte("priority", 3)
  .lt("due_at", new Date())        // less than (dates are accepted)
  .lte("estimate", 8)
  .like("title", "Write%")         // case-sensitive pattern
  .ilike("title", "%docs%")        // case-insensitive pattern
  .in("status", ["open", "blocked"])
  .notIn("status", ["archived"])
  .is("deleted_at", null)          // is null (or true / false)
  .isNot("assignee_id", null);     // is not null

(pb.from_("tasks")
   .eq("done", False)
   .neq("owner_id", user_id)
   .gt("priority", 2)
   .gte("priority", 3)
   .lt("due_at", now)
   .lte("estimate", 8)
   .like("title", "Write%")
   .ilike("title", "%docs%")
   .in_("status", ["open", "blocked"])
   .not_in("status", ["archived"])
   .is_("deleted_at", None)
   .is_not("assignee_id", None))

const { data } = await pawabase.from("tasks").where({
  done: false,
  priority: { gte: 3 },
  status: { in: ["open", "blocked"] },
  deleted_at: { is: null },
});

data = pb.from_("tasks").where(done=False, priority={"gte": 3}, status={"in": ["open", "blocked"]}).execute().data