Can I order by a formula

[draklowell]

I want to order by formula between two columns. In sql query it look like SELECT * FROM places ORDER BY (latitude-1)+(longitude-1) in SQLite, but i need it in QuerySet. Sorry, my english is well

[harrisj]

To echo this request, it would be useful to be able to provide a raw string for the order declaration that doesn't lookup fields. This would allow me to do ordering based on summing different fields or doing an order by RANDOM(), both of which require me to construct a raw SQL query

[long2ice]

Yes, this is a good feature.

[long2ice]

Current support order by function already, like

await model.annotate(a=Length('field')).order_by('-a')

but not for expression, like

await model.annotate(idp=F("id") + 1).order_by("-idp").values_list("id", "idp")

And will support that in next release.