how to use 'select' with 'with' ?

@tykus Can you explain more in detail ?

What is the meaning of 'separate query' ?

@binggle eager-loading a relation means you have a separate query; see for yourself

\DB::listen(fn ($query) => dump($query->sql, $query->bindings));
$user = User::with('role')->first();

The first query gets the User, the second (separate) query gets the associated Role - Eloquent then loads the role into the User instance so it available as a property

@tykus Thanks for so fast reply.

Actually I am using 'power-components/livewire-powergrid' package.

I have to return Eloquent Builder not Collection.

please see the followings.

public function datasource(): ?Builder
{
    return User::query()
            ->join('roles', 'users.role_id', '=', 'roles.id')
            ->select('users.*', 'roles.name as role');

}

But I want to make simple something like..

public function datasource(): ?Builder
    return User::query()
            ->with('role')
            ->select('users.*', 'roles.name as role');
}

User model and Role Model has same field, name.

I would like to make it simple and not using join statement.

@binggle I suppose you are working with Eloquent Model objects in the view anyway, so:

public function datasource(): ?Builder
{
    return User::('role'); // use $user->role->name in the view
}

If you are not working then the join is okay too:

public function datasource(): ?Builder
    return User::select('users.*', 'roles.name as role_name');  // $user->role_name
}

@tykus yes. this is working a half.

public function datasource(): ?Builder
{
    return User::with('role'); // use $user->role->name in the view
}

But the problem is that two table are using same field , 'name' .

'roles.name' should be returned explicitly together with users all field in query .

That is why I asked how to use 'select with with ' ..

I guess there could be a solution.

Thanks..

@binggle if this...

'roles.name' should be returned explicitly together with users all field in query .

then... eager-loading is not the solution, you must alias one of the name columns 🤷‍♂️

@binggle eager-loading is supported. So, is the problem that two columns have the same header row; it appears that you can modify that https://livewire-powergrid.com/#/table/include-columns?id=column-methods

@tykus

Ah. You really genius. Yes You are right.

I added an accessor on Role Model.

    public function getRoleNameAttribute()
    {
        return $this->attributes['name'];
    }

It returns 'roles.name' with the name of 'roles.role_name' .

Thank you so much.

@binggle if you're all set, please mark the thread closed.