Annotate to DB field name

[cold ferry]

Hello folks,
Is it possible to return object instead of id on foreign relation with annotate? eg:

class Times(models.Model)
  employee = models.ForeignKey(Employee,...

class Viewset()

def get_queryset(self):
        return (
            super()
            .get_queryset()
            .select_related("employee__user")
            .annotate(employee_full_name=Concat("employee__user__first_name", Value(" "), "employee__user__last_name", output_field=CharField()))
        ).order_by("-start_stamp")


what i need:
employee:{
"id",
"full_name":"",
}

[astral swift]

Yes, I think JSONObject will help you, if I understand correctly

[cold ferry]

my problem is that i cant annotate to same as db field name:
ValueError: The annotation 'employee' conflicts with a field on the model.

[astral swift]

Yes, so you would need to name it something else.

[cold ferry]

yes i know, but my question was if there is anyway to keep the employee name

[astral swift]

so annotate full_name onto the employee?

[cold ferry]

yes

like nested serializer

which gives me data about employee instead of its id

[astral swift]

I wonder if annotate(employee__full_name=Concat("employee__user__first_name", Value(" "), "employee__user__last_name", output_field=CharField())) would work? (note the __ in the definition of the variable)

[cold ferry]

ill try it out

[cold ferry]

values() returns:
'employee__full_name': 'Name LastName',