Getting the query builder to output its raw SQL query as a String

Question

Hello everyone,

Here given the following code:

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

I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users.

How can i do this?

Please help me

Thank you!!

Answer 1

Hello,

DB::QueryLog() only work after you execute the query $builder->get(). if you want to get the query before execute the query you can use $builder->toSql() method. this is the example how to get the sql and bind it:

    $query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
    $query = vsprintf($query, $builder->getBindings());
    dump($query);

    $result = $builder->get();

or  just make your query error like calling for unexist table or column, you will see the generated query in exception XD

Hope this works!

Thank you!