SQL to Laravel Eloquent Converter

A simple tool to help you convert raw SQL queries into Laravel Eloquent / Query Builder.

Features

  • Converts raw SQL queries to Laravel Query Builder / Eloquent.
  • Helps construct queries following Laravel documentation standards.

Example Usage

SQL Input 
SELECT
    department_id,
    count(*)
FROM
    members
    LEFT JOIN details AS d ON d.member_id = members.member_id
WHERE
    ( age = 25 OR ( salary = 2000 AND gender = 'm' ) )
    AND id > 15
GROUP BY
    department_id
HAVING
    height > 1.60
Eloquent Output 
DB::table('members')
->select('department_id',DB::raw('count(*)'))
->leftJoin('details AS d','d.member_id','=','members.member_id')
->where(function ($query) {
        $query->where('age','=',25)
          ->orWhere(function ($query) {
            $query->where('salary','=',2000)
                  ->where('gender','=','m');
        });
})
->where('id','>',15)
->groupBy('department_id')
->having('height','>',1.60)
->get();

If you have any questions or feedback, please leave a comment below.