Is it possible to "join" django queryset with custom sql query?

Question

Django

There is a rather complex aggregating (? like so) query.

SELECT mymodel.id as id,
SUM(...),
SUM(...)
COUNT(...)
FROM anothermodel
JOIN ... JOIN ...
WHERE mymodel.id IN (1,2,3,4)
GROUP BY mymodel.id,  anothermodel.country

It can be easily called - MyModel.objects.raw(query). Separately, it works fine - and the aggregated data is available and the model fields are automatically joined by id.
Is it possible vice versa? There is a queryset MyModel.objects.filter(...).exclude(...). How to attach raw request data to it? Ordinary extras are not suitable, because the data is retrieved from another table (which is connected through four foreign keys).

Answer 1

It is possible through extra / where, just the request will not be through join, but through a subquery
select ... where id not in (select ...)

Answer 2

Make a database view from the request and add it as an unmanaged model.