Is soft_delete supposed to use "deleted_at IS NULL"?

[everdrone]

Consider the following model for a m2m relationship:

type Task struct {
	bun.BaseModel `bun:"table:task"`

	ID        string    `bun:"type:varchar(31),pk"`
	DeletedAt time.Time `bun:",soft_delete"`
	// ...
	Assignees []*User `bun:"m2m:tasks_to_users,join:Task=User"`
}

type TasksToUsers struct {
	bun.BaseModel `bun:"table:tasks_to_users"`

	TaskID string `bun:"type:varchar(31),pk,unique:tasks_users"`
	Task   *Task  `bun:"rel:belongs-to,join:task_id=id"`
	UserID string `bun:"type:varchar(31),pk,unique:tasks_users"`
	User   *User  `bun:"rel:belongs-to,join:user_id=id"`
}

type User struct {
	bun.BaseModel `bun:"table:user"`

	ID        string    `bun:"type:varchar(31),pk"`
	DeletedAt time.Time `bun:",soft_delete"`
	// ...
	AssignedTasks []*Task `bun:"m2m:tasks_to_users,join:User=Task"`
}

This is the generated query:

SELECT
  "tasks_to_users"."task_id", "tasks_to_users"."user_id", "user"."id" AS "user__id",
  "user"."created_at"  AS "user__created_at",
  # ...
  "user"."username" AS "user__username"
FROM
  "tasks_to_users" 
LEFT JOIN
  "user" AS "user" 
ON 
  ("user"."id" = "tasks_to_users"."user_id") 
AND 
  "user"."deleted_at" IS NULL 
WHERE
  (task_id IN ('t_1', 't_0', 't_2'))

I'm trying to query all the users assigned to multiple tasks with:

res := make([]*model.TasksToUsers, len(keys))
err := model.DB.NewSelect().
	Model(model.TasksToUsersModel).
	Where("task_id IN (?)", bun.In(keys)).
	Relation("User").
	Scan(context.Background(), &res)

It results in the User field being always nil because deleted_at IS NULL is never true
deleted_at uses 0001-01-01 00:00:00+00 value as null

To try it out I tried to remove deleted_at IS NULL from the query and it worked as intended.