Pivot on Union Queryset : Calling QuerySet.distinct() after union() is not supported.

[Bbillyben]

Hi there,

I'm trying to get some dashboarded datas on some models, and even between models.

issue description : When I union 2 queryset of models objects, and then try to pivot with pivot_table, I've got the issue :

django.db.utils.NotSupportedError: Calling QuerySet.distinct() after union() is not supported.

Step to reproduce :

1. define a model
2. add some new instances
3. : a=models.MYModel.objects.filter(pk=1) b=models.MYModel.objects.filter(pk=2) c=a.union(b) pivot_table = pivot(c, 'field1', 'field2', 'field3')

=> raise the error above

is there anything I missed ?

infos : django v4.1.2 python v3.9.2 django-pivot v1.9.0