Model select from json column returns `json_unquote..`

Can you try this?

App\Activity::whereIn('id', [16,25,50])->get(['id', 'name->>en'])

Tried, the same. Just in case PHP 7.2.19

>>> App\Experience::whereIn('id', [16,25,50])->get(['id', 'name->>en'])
=> Illuminate\Database\Eloquent\Collection {#3019
     all: [
       App\Experience {#3040
         id: 16,
         json_unquote(json_extract(`name`, '$.">en"')): null,
       },
       App\Experience {#3039
         id: 25,
         json_unquote(json_extract(`name`, '$.">en"')): null,
       },
       App\Experience {#3038
         id: 50,
         json_unquote(json_extract(`name`, '$.">en"')): null,
       },
     ],
   }

Ok try with a select instead.

App\Experience::whereIn('id', [16,25,50])->select('id', 'name->>en as name')->get();

>>> App\Experience::whereIn('id', [16,25,50])->select('id', 'name->>en as name')->get();
=> Illuminate\Database\Eloquent\Collection {#3028
     all: [
       App\Experience {#3027
         id: 16,
         name: null,
       },
       App\Experience {#3026
         id: 25,
         name: null,
       },
       App\Experience {#3025
         id: 50,
         name: null,
       },
     ],
   }

weird :)

https://stackoverflow.com/a/46291847/1305117

I'm using MySql 8.0.19 in Laragon, which I suppose has to be compatible with field->key notation :)

This is an example of the data in the table

>>> App\Activity::find(16)
=> App\Activity {#3028
     id: 16,
     name: "{"en": "8844ge32v"}",
     description: "{"en": "Rem necessitatibus aut perferendis commodi laborum ullam ut. Illum cumque itaque vel magnam perspiciatis vel alias."}",
     product: "{"en": "Et eum doloribus facere rerum rerum perferendis itaque. Omnis sequi animi perferendis atque. Est magni tempore eum deleniti eligendi. Quas repellat sit ab reprehenderit nobis aspernatur quis."}",
     updated_by: null,
     created_at: "2020-02-23 21:11:06",
     updated_at: "2020-02-23 21:11:06",
   }

Oh sorry missed that. Can you try the select version with only one arrow?

Sadly the same

>>> App\Activity::where('id', 1)->get('name->en')
=> Illuminate\Database\Eloquent\Collection {#3031
     all: [
       App\Activity {#3034
         json_unquote(json_extract(`name`, '$."en"')): "46939egi4",
       },
     ],
   }

You need a single arrow and an alias:

App\Activity::where('id', 1)->get('name->en as name')

It works!

>>> App\Activity::where('id', 1)->get(['id', 'name->en as name'])
=> Illuminate\Database\Eloquent\Collection {#3033
     all: [
       App\Activity{#3027
         id: 1,
         name: "46939egi4",
       },
     ],
   }

Can you explain why native doesn't solve it and I have to use alias?