Our Latest Blog

Convert Your SQL to Laravel Builder with Orator

By CodeBrisk 15 Dec 2017
Convert Your SQL to Laravel Builder with Orator

You can convert raw and legacy SQL queries into a Laravel database query builder version with Orator, an online tool by Maurice Calhoun. This generator could also be an excellent tool for someone learning Laravel, as it can help them translate SQL queries into query builder objects, as learning a new ORM can sometimes be a challenge for new developers.

You simply enter your SQL query, and the generator returns a database query builder. For example, take this SQL query:

select posts.id, posts.title, posts.body from posts
where posts.author_id = 1
order by posts.published_at DESC
limit 10;

The online tool converts it into the following Laravel database query:

DB::select('posts.id','posts.title','posts.body')    
   ->from('posts')   
   ->where('posts.author_id', '=', 1)    
   ->orderBy('posts.published_at', 'DESC')    
   ->limit(10)    
   ->get();

Try out this SQL to Laravel Query Builder tool online. One thing to note is that you have to replace “backticks” (`) into strings to get it working because the generated builder gives you backticks when it should give you a string. In PHP, the backticks are execution operators.

For those learning how to work with Laravel’s query builder should check out the query builder documentation. We’ve also recently written about optimizing queries with eager loading and quickly dumping Laravel queries which should help you get up to speed on working with databases in Laravel.