django query column
# Import necessary modules
from django.db.models import F, ExpressionWrapper, fields
# Define the queryset with annotation for the calculated column
queryset = YourModel.objects.annotate(
calculated_column=ExpressionWrapper(
F('existing_column') + F('another_column'),
output_field=fields.FloatField()
)
)
# Access the result using the annotated column
result = queryset.values('existing_column', 'another_column', 'calculated_column')