You will likely end up with convoluted INSERT OR IGNORE INTO... WITH ...SELECT statement with WITH clause which first detects existing pairwise matching rows an

You will likely end up with convoluted INSERT OR IGNORE INTO... WITH ...SELECT statement with WITH clause which first detects existing pairwise matching rows and if they are found, the SELECT generates values which purposedly violate some other unique constraint. If that's practically or philosophically more acceptable to you :)