How To Convert Laravel Query To SQL Query

In this article, we will see how to convert a laravel query to an SQL query. Many times we required laravel query builder to its raw SQL query as a string. Laravel provides different ways to get raw SQL queries. You can get SQL queries using the toSql() query builder method. Also, you can use the laravel query log to get SQL queries in laravel. For getting the query logs we will use enableQueryLog() method.

 So, let's see how to get the raw SQL query from a laravel.

In this example, we will use the toSql() method to get raw SQL queries. toSql() get the SQL representation of the query and return the string value. This method doesn't show the whole query if your query is more complex or if there are sub-queries.

SQL Query Example:

SELECT * FROM articles WHERE status='published';

Laravel Query Example:

$articles = Article::where('status', 'published')->get();

Use the toSql() method, you can just change the get() part in the above query with toSql().

$article = Article::where('status', 'published')->toSql();

Output:

"select * from `articles` where `status` = ?"

Laravel can optionally log into the memory of all queries that have been run for the current request. You can enable the log using the enableQueryLog() method.

public function store(Request $request){
    \DB::enableQueryLog();

    Post::where('is_active', '=', '1')        
    ->orderBy('publish_date', 'desc')
    ->limit(15)
    ->get();

    dd(\DB::getQueryLog());
}

Output:

array:1 [▼
  0 => array:3 [▼
    "query" => "select * from `posts` where `is_active` = ? order by `publish_date` desc limit 15"
    "bindings" => array:1 [▶]
    "time" => 7.03
  ]
]

So, you can get out in array format with the query and execution time of the query.

You might also like:

• Read Also: How To Get Last 15 Days Records In MySQL
• Read Also: How To Import CSV File In MySQL Using Node.js
• Read Also: How to Use JSON Data Field in MySQL Database
• Read Also: How To Fix MySQL Shutdown Unexpectedly In XAMPP