Join other table in the inertiaTable QueryBuilder request

[landryjohn]

I wish to know the proper way to write a querybuilder request for inertia table which can make me use foreign fields in the table. (As weel as fields concatanations).

When i use for instance

$orders = QueryBuilder::for(Order::class) ->defaultSort('created_at')
->allowedIncludes(['user'])
->select('orders.id', 'orders.total_price',
DB::raw("concat(users.last_name, ' ', users.first_name) as full_name"),
'orders.paid', 'orders.shipped', 'orders.created_at', 'users.email')
->join('users', 'orders.user_id', '=', 'users.id')
-> ...

It works, but i lost all the datatables functionnalities (Filter, Search, Sort, ...)

Thank