[Answered ]-Django QuerySet equivalent for SQL's between and

You’re right, the __range method won’t work, so no, there is no way to use the Django ORM to create the SQL you are after.

Is there a problem with using the .filter method which you came up with?