PHPackages                             xinningsu/laravel-raw-sql - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. xinningsu/laravel-raw-sql

ActiveLibrary

xinningsu/laravel-raw-sql
=========================

Get raw sql from laravel query builder via toRawSql method.

v1.0(5y ago)0257MITPHPPHP ^7.0 || ^8.0

Since Jan 11Pushed 5y ago1 watchersCompare

[ Source](https://github.com/xinningsu/laravel-raw-sql)[ Packagist](https://packagist.org/packages/xinningsu/laravel-raw-sql)[ RSS](/packages/xinningsu-laravel-raw-sql/feed)WikiDiscussions master Synced today

READMEChangelog (1)Dependencies (4)Versions (2)Used By (0)

Laravel Raw SQL
===============

[](#laravel-raw-sql)

Get raw sql from laravel query builder via toRawSql method.

[![MIT licensed](https://camo.githubusercontent.com/7013272bd27ece47364536a221edb554cd69683b68a46fc0ee96881174c4214c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d626c75652e737667)](./LICENSE)[![Build Status](https://camo.githubusercontent.com/b857870933622d8041a66a1a5766195313cc53a0d585a0b598781719aee6d76d/68747470733a2f2f6170692e7472617669732d63692e6f72672f78696e6e696e6773752f6c61726176656c2d7261772d73716c2e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/xinningsu/laravel-raw-sql)[![Coverage Status](https://camo.githubusercontent.com/de77809dc7d7d03c9dd41b553c7c1557134d9b58da3a0e7c701e7fe1400a95d5/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f78696e6e696e6773752f6c61726176656c2d7261772d73716c2f62616467652e7376673f6272616e63683d6d6173746572)](https://coveralls.io/github/xinningsu/laravel-raw-sql)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/f7dd8576788b0824de46266f54e78937839066488d99d1845fdad47c1e73cb7f/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f78696e6e696e6773752f6c61726176656c2d7261772d73716c2f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/xinningsu/laravel-raw-sql)[![Code Intelligence Status](https://camo.githubusercontent.com/61db1e214ca969b49eb793782e9213a39837b98f4f82d4e8910903b4f20a38a4/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f78696e6e696e6773752f6c61726176656c2d7261772d73716c2f6261646765732f636f64652d696e74656c6c6967656e63652e7376673f623d6d6173746572)](https://scrutinizer-ci.com/g/xinningsu/laravel-raw-sql)[![Quality Gate Status](https://camo.githubusercontent.com/386b719c60356abeb54050735c33d6135c06dbe33e46dea3b86380673b067870/68747470733a2f2f736f6e6172636c6f75642e696f2f6170692f70726f6a6563745f6261646765732f6d6561737572653f70726f6a6563743d78696e6e696e6773755f6c61726176656c2d7261772d73716c266d65747269633d616c6572745f737461747573)](https://sonarcloud.io/dashboard?id=xinningsu_laravel-raw-sql)[![Reliability Rating](https://camo.githubusercontent.com/eafabc992ea092f51931644c921e5ea6f365dd428553c9993430226878f37e24/68747470733a2f2f736f6e6172636c6f75642e696f2f6170692f70726f6a6563745f6261646765732f6d6561737572653f70726f6a6563743d78696e6e696e6773755f6c61726176656c2d7261772d73716c266d65747269633d72656c696162696c6974795f726174696e67)](https://sonarcloud.io/dashboard?id=xinningsu_laravel-raw-sql)[![Security Rating](https://camo.githubusercontent.com/9054c7395ed8415076f3a64fef9d8478f2feefaa06baad7d031bac22382856c3/68747470733a2f2f736f6e6172636c6f75642e696f2f6170692f70726f6a6563745f6261646765732f6d6561737572653f70726f6a6563743d78696e6e696e6773755f6c61726176656c2d7261772d73716c266d65747269633d73656375726974795f726174696e67)](https://sonarcloud.io/dashboard?id=xinningsu_laravel-raw-sql)[![Maintainability](https://camo.githubusercontent.com/361ad96283dd333822e3e84e5bb44ae5a64eca405f859419aca2d699448fd88e/68747470733a2f2f6170692e636f6465636c696d6174652e636f6d2f76312f6261646765732f31383636393338366365363535333262323238662f6d61696e7461696e6162696c697479)](https://codeclimate.com/github/xinningsu/laravel-raw-sql/maintainability)

Background
==========

[](#background)

Using `toSql` method to output the sql of query builder, it's something with `?`, not the raw sql.

```
use Illuminate\Support\Facades\DB;
use App\Models\User;

echo DB::table('user')->where('id', 1)->where('verified', 1)->toSql();
// or
echo User::where('id', 1)->where('verified', 1)->toSql();
```

The output would be something like this with `?`:

```
select * from `user` where `id` = ? and `verified` = ?
```

I exactly want the raw SQL like this:

```
select * from `user` where `id` = 1 and `verified` = 1
```

Now with this package, we can get the raw sql via toRawSql.

```
echo DB::table('user')->where('id', 1)->where('verified', 1)->toRawSql();
// or
echo User::where('id', 1)->where('verified', 1)->toRawSql();
```

Will output

```
select * from `user` where `id` = 1 and `verified` = 1
```

Installation
============

[](#installation)

Require this package with composer.

```
composer require xinningsu/laravel-raw-sql

```

As this package using laravel [Package Discovery](https://laravel.com/docs/8.x/packages#package-discovery) to discover `Sulao\RawSql\ServiceProvider::class`, so there's no need to do anything else, please use it directly.

License
=======

[](#license)

[MIT](./LICENSE)

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

1945d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/7513c529acb322b54c46bef8011275fe734f9d00944c3f3921cebc21c0cd2ed0?d=identicon)[xinningsu](/maintainers/xinningsu)

###  Code Quality

TestsPHPUnit

Code StylePHP\_CodeSniffer

### Embed Badge

![Health badge](/badges/xinningsu-laravel-raw-sql/health.svg)

```
[![Health](https://phpackages.com/badges/xinningsu-laravel-raw-sql/health.svg)](https://phpackages.com/packages/xinningsu-laravel-raw-sql)
```

###  Alternatives

[anourvalar/eloquent-serialize

Laravel Query Builder (Eloquent) serialization

11320.2M21](/packages/anourvalar-eloquent-serialize)[namu/wirechat

A Laravel Livewire messaging app for teams with private chats and group conversations.

54324.5k](/packages/namu-wirechat)[statamic-rad-pack/runway

Eloquently manage your database models in Statamic.

135192.6k5](/packages/statamic-rad-pack-runway)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)