Django ORM - how to express sql query?

Question

Django

Actually the question is how to express such a mysql expression

SELECT lvl FROM userlevel WHERE lvlxp - UserXp <= 0

using django orm?

Answer 1

Alternatively using the F() operator and annotations :

Userlevel.objects.annotate(difference=F('lvlxp') - F('UserXp'))\
    .filter(difference__lte=0).values_list('lvl', flat=True)

Answer 2

https://docs.djangoproject.com/en/2.2/topics/db/ag...
Userlevel .objects.filter(lvlxp__lte=UserXp)