Is it possible to use Meilisearch for making searches, that is currently done in MySql through joining different tables?

Question

For example is Meilisearch is capable to make the same query as the one with joining different tables like:

                        ->leftJoin('clients as c', 'n.ufid', '=', 'c.id')
                        ->leftJoin('partners', 'n.partnerid', '=', 'partners.id')
                        ->leftJoin('users as u1', 'u1.id', '=', 'n.salesman')
                        ->leftJoin('users as u2', 'u2.id', '=', 'n.modifiedby’)
                        ->select(DB::raw("CONCAT(c.familyname,' ',c.xname) AS full_name"), 'partners.name as pname', 'u1.name as sname', 'u2.name as modbyname',  'n.id', 'n.note', 'n.date')
                        ->where("n." . $field, 'LIKE', '%'.$term.'%')```