How Can I Retrieve the Raw SQL Query from Laravel's Query Builder?

Retrieving Raw SQL Queries from the Query Builder

In some scenarios, developers may need to retrieve the exact SQL query that the query builder will generate for a given operation. For instance, consider the following query:

DB::table('users')->get();

This query will produce a SQL statement similar to "SELECT * FROM users". To obtain this raw SQL query as a string, you can utilize the toSql() method.

$sqlQuery = DB::table('users')->toSql();

Upon executing this code, the variable $sqlQuery will contain the raw SQL query, which in this case would be "SELECT * FROM users".

Note that the toSql() method can be applied to both query builder and Eloquent queries. However, unlike first() or get(), it does not execute the query. This allows developers to inspect the SQL at any stage of query construction without actually executing it.

The above is the detailed content of How Can I Retrieve the Raw SQL Query from Laravel's Query Builder?. For more information, please follow other related articles on the PHP Chinese website!