Op.ne, Op.not and Op.notIn exclude null values automatically

[Vitomir2]

Hello all :)

I have found that the abovementioned operators are excluding records that contain null values. I don't know if this is a bug or this is how it works. I know that null is treated as unknown or undefined value SQL databases, but still, I think this shouldn't be the case. Here is the code:

const records = await Model.findAll({
            where: {
                userId: this.id,
                provider: { [Op.ne]: "main-provider" },
            },
        });

As we can see, I am looking for records that are with current user.id and provider != "main-provider". This correctly applies the filter as I can see in the terminal, however, it excludes the records that are provider = NULL. I have found this as a workaround:

const records = await Model.findAll({
            where: {
                userId: this.id,
                [Op.or]: [{ provider: { [Op.not]: "main-provider" } }, { provider: null }],
            },
        });

I will be very happy if one can explain to me if that is how it is supposed to be working. I do not like this workaround, because the previous variant seems more meaningful to me and requires less code/conditions.