arnoldfederis/builder-to-sql is a Laravel package for render eloquent or query builder to sql.
It currently has 1 GitHub stars and 4.233 downloads on Packagist.
Install it with composer require arnoldfederis/builder-to-sql.
Discover more Laravel packages by arnoldfederis
or browse all Laravel packages to compare alternatives.
Last updated
Render Eloquent or Query builder to Sql.
In this package will automatically replace all ? from toSql() result with your bindings.
This is useful when you don't want to manual query.
Laravel 5 to latest version
PHP ^7.0
composer require arnoldfederis/builder-to-sql
Import BuilderToSql class or use the helper function.
class TestController extends Controller
{
public function index()
{
/* Class base */
// Query Builder
return BuilderToSql::render(DB::table('users')->where('email', '[email protected]')->orderByDesc('created_at'));
// Eloquent Builder
return BuilderToSql::render(User::where('email', '[email protected]')->orderByDesc('created_at'));
/* Function base */
// Query Builder
return query_builder_to_sql(DB::table('users')->where('email', '[email protected]')->orderByDesc('created_at'));
// Eloquent Builder
return query_builder_to_sql(User::where('email', '[email protected]')->orderByDesc('created_at'));
// Result
// select * from users where email = '[email protected]' order by created_at desc
}
}
This is a free software licensed under the MIT license.
