Query Viewer

This package adds custom methods to eloquent and database query builder for getting sql query. (question marks replaced with values)

Package Description

Laravel’s toSql() method gives you sql query without bindings replaced. (see question marks below)

\DB::table('users')->select('name')->where('id', 5)->toSql();

// select `name` from `users` where `id` = ? and `name` = ?

With this package you have getSql() method. Which gives you same result with bindings replaced.

\DB::table('users')->select('name')->where('id', 5)->getSql();

// select `name` from `users` where `id` = 5 and `name` = 'laravel'

Usage

Please see README for details.