Get translated value for name and slug when requesting data for API

[noplanman]

Kind of related to #198, I'm looking for a way to fetch all tags already translated.

Basically, I'm currently trying to get and show the list of tags for an API call:

public function index(): JsonResponse
{
    return response()->json(
        Tag::query()
            ->select('id', 'name', 'created_at')
            ->latest()
            ->paginate(),
        200
    );
}

But this gives me the name and slug fields as objects with ALL translations, instead of the locale translated value itself.

At the moment the only solution I've come up with is to create a custom scope on my Tag model, like this:

public function scopeTranslated(Builder $query, array $columns = ['name', 'slug'], string $locale = null): Builder
{
    $locale = $locale ?? app()->getLocale();

    foreach ($columns as $column) {
        $query->selectRaw("JSON_UNQUOTE(JSON_EXTRACT({$column}, '$.\"{$locale}\"')) as `{$column}_translated`");
    }

    return $query;
}

Adding the scope will add the name_translated and slug_translated fields, but it's a bit weird to have to deal with that on the front end. I tried to name the columns in the scope name and slug (i.e. as `{$column}`), but that results in them having a value of null when requesting the resource, no idea why 😕

How do I do this?