Sorting results in error when prefix of column is not defined #3237
Description
From version 12.1.1 and after we have encountered an error on sorting on columns without a table prefix. Although the sorting columns are unique between the joined tables the sorting results in error because the prefix is enforced wrongly to the primary table.
Example eloquent query:
$query = Member::select(['members.*', 'qprofiles.id as qprofiles_id', 'qprofiles.active as qprofiles_active', 'qprofiles.date', 'qprofiles.updated_at', 'qprofiles.vision', 'qprofiles.talent', 'qprofiles.competence', 'qprofiles.performance', 'qprofiles.attrition', 'qprofiles.operating', 'qprofiles.profile_role', 'qprofiles.score', 'qprofiles.smart_questions', 'qprofiles.time_in_role', 'qprofiles.reward', 'qprofiles.development_scan', 'qprofiles.organization_design_issue', 'qprofiles.campaign_id', ]) ->with(['department', 'fields']) ->join('departments', 'members.department_id', '=', 'departments.id') ->leftjoin('qprofiles', function ($join) { $join->on('members.id', '=', 'qprofiles.member_id'); $join->on('qprofiles.active', '=', DB::raw('1')); }) ->where('departments.organization_id', Auth::user()->organization_id) ->where('members.active', 1); return DataTables::of($query ) ->addIndexColumn() ->setRowId('id') ...