How to write this raw sql subquery as native django query?

[cehceh]

I have worked on SQL for 3 years when I used .Net technology, And I liked SQL command, Really it’s magnificent. But I gave me chance to penetrate ORM you will get more robust and secure query by it.

@rabarberski

SELECT *
            FROM Loans
            INNER JOIN (
                SELECT LibAccountId as LAI, Title AS T,StartDate as SD, RemoteId AS RI, MAX(EndDate) AS max_enddate
                From Loans
                GROUP BY LibAccountId, Title, StartDate, RemoteId
            ) last_by_enddate ON
                Loans.LibAccountId = LAI
                AND Loans.Title = T
                AND Loans.StartDate = SD
                AND  (Loans.RemoteId= RI  OR (Loans.RemoteId IS NULL AND RI IS NULL))
                AND Loans.EndDate = last_by_enddate.max_enddate
            ORDER BY Loans.EndDate DESC
            """
        )

I think this query is not difficult to be a result of ORM,
The Left Outer Join is more difficult but I can make it by ORM.
I have no ORM query for your SQL query now.
But If you think well, and give yourself another chance to try ORM you will have benefits.
You can use(filter, values, values_list, select_related, preftch_related, annotate and aggregate with order_by and distinct) then you get what you want .
Try to print the ORM query to the console by (orm_qs.query) to see the SQL equivalent,
Give us your models and you will get what you want …
Also when using ORM you can use(Case, When and etc) of SQL commands
Take a look at

• Complex SQL through Django ORM
• Django ORM Query
• Complex SQL query and Django ORM
• Advanced Django ORM Queries
• Making queries | Docs