Question

0

168

Views

Specify sql expression as column name in a django orm query

Look at this query:

select 'DEFAULT_STRING' as category from foo

Here, we don't really have the column category in the table, but we just use a string literal to represent this column value in all rows returned by the query. In place of a string literal, we could have any valid SQL expression above. Is there some way to have this query in the django ORM?

over 4 years ago · Santiago Trujillo

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-05-26T13:57:18.497Z

A handy way of doing this is to annotate with RawSQL query expression.

from django.db.models.expressions import RawSQL
qset = Foo.objects.annotate(category=RawSQL("select 'DEFAULT_CATEGORY'", ()))

Please let me know in the answers if there are better ways of doing this.

0

168

Specify sql expression as column name in a django orm query

1 answers

0

Find remote jobs

Andres GPT