arnoldfederis / builder-to-sql
Render Eloquent or Query builder to Sql
Installs: 4 232
Dependents: 0
Suggesters: 0
Security: 0
Stars: 1
Watchers: 1
Forks: 0
Open Issues: 0
Requires
- php: ^7.0
- illuminate/database: ^5.0|^5.1|^5.2|^5.3|^5.4|^5.5|^5.6|^5.7|^5.8|^6.0|^7.0|^8.0
This package is auto-updated.
Last update: 2025-06-24 22:39:28 UTC
README
Description
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.
Compatibility
Laravel 5 to latest version
PHP ^7.0
How to install
composer require arnoldfederis/builder-to-sql
How to use
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', 'query_builder_to_sql@email.com')->orderByDesc('created_at')); // Eloquent Builder return BuilderToSql::render(User::where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at')); /* Function base */ // Query Builder return query_builder_to_sql(DB::table('users')->where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at')); // Eloquent Builder return query_builder_to_sql(User::where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at')); // Result // select * from users where email = 'query_builder_to_sql@email.com' order by created_at desc } }
License
This is a free software licensed under the MIT license.