New

Just launched: Vueblocks, a brand-new search engine for Vue packages! Explore Vueblocks →

arnoldfederis/builder-to-sql

Render Eloquent or Query builder to Sql
4,233 1
Install
composer require arnoldfederis/builder-to-sql:dev-master
PHP:^7.0
License:MIT
Last Updated:Jul 24, 2021
Links: GitHub  ·  Packagist
Maintainer: arnoldfederis

Laravel Builder to SQL

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.

Related Packages

doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database s...

660,512,042 9,702
laravel/framework

The Laravel Framework.

625,568,548 34,998
laravel/tinker

Powerful REPL for the Laravel framework.

531,591,559 7,442
laravel/serializable-closure

Laravel Serializable Closure provides an easy and secure way to serialize closur...

450,320,528 608
nunomaduro/collision

Cli error handling for console/command-line PHP applications.

424,642,029 4,662