bulk_create_with_history N+1 when model has unique_together constraint

[Ctesias]

Describe the bug
With a model using a unique_together constraint I see bulk_create_with_history making existence call checks to the DB for the constrained columns for every object being created. They look like

SELECT (1) AS 'a' FROM related_table_a where related_table_a.id = %s LIMIT 1
SELECT (1) AS 'a' FROM 'target_table' WHERE ('target_table'.'other_unique_together_col' = %s AND 'target_table'.'related_table_id' = %s) LIMIT 1

Here's the relevant code in my model making the call:

target_models = []
for data in cleaned_data.values():
    target_models.append(
        TargetModel(
            unique_constraint_related_model=prefetched_model_instance,
            other_unique_constraint_b=data.get("some_data"),
            c=data.get("c")
        )
    )
bulk_create_with_history(target_models, model=TargetModel)

To Reproduce
Steps to reproduce the behavior:

1. create two models A and B
2. create a unique together constraint in model B that is Model A and some other column
3. create a bunch of B model instances
4. use bulk_create_with_history() on the B instances

Expected behavior
There would be one insert call to the Model B table with the new values

Environment (please complete the following information):

• OS: ubuntu 18.04.6
• Django Simple History Version: 3.2.0
• Django Version: 3.2.13
• Database Version: MariaDB 10.3.39

[Ctesias]

some additional discovery. Here's a printout of the connection calls increase when I create a bunch of TargetModels on my django shell

In [13]: target_models = [
    TargetModel(
        unique_constraint_related_model=prefetched_related_object,
        other_unique_constraint_b=str(i)
    ) 
    for i in range(100)
]

In [14]: print(len(connection.queries))
7    <---- these are from some preliminary data gathering to make the TargetModels

In [15]: bulk_create_with_history(parcels, model=Parcel)
Out[15]:
[...<list of objects created redacted for brevity>]

In [16]: print(len(connection.queries))
210  <----I'd expect this to be 8 (maybe 10) but it has 2 extra hits for each object being made