PHPackages                             hogus/generate-query-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. [Database & ORM](/categories/database)
4. /
5. hogus/generate-query-sql

ActiveLibrary[Database & ORM](/categories/database)

hogus/generate-query-sql
========================

generate queries to sql

1.0(2y ago)09MITPHP

Since Aug 17Pushed 2y ago1 watchersCompare

[ Source](https://github.com/hogus2037/generate-query-sql)[ Packagist](https://packagist.org/packages/hogus/generate-query-sql)[ RSS](/packages/hogus-generate-query-sql/feed)WikiDiscussions main Synced yesterday

READMEChangelogDependencies (2)Versions (2)Used By (0)

To generate SQL from Laravel queries
====================================

[](#to-generate-sql-from-laravel-queries)

insert
------

[](#insert)

```
use Hogus\Query\GrammarGenerate;

$values = [
    'name' => 'Tom',
    'age' => 12
];

$generate = new GrammarGenerate();
$generate->insert('user', $values)->save('user_insert');
// insert into `user` (`name`, `age`) values ('Tom', '12');
```

update
------

[](#update)

```
$values = [
    'name' => 'Tom',
    'age' => 12
];

$generate->update('user', $values, ['id' => 1]);
// or
$generate->update(DB::table('user')->where('id', 1), $values);
// save to file
$generate->save('user_sql');
// update `link_user` set `name` = 'Tom', `age` = '13' where (`id` = '1');
```

delete
------

[](#delete)

```
$generate->delete('user', ['id' => 1]);
// or
$generate->delete(DB::table('user')->where('id', 1));

// save to file
$generate->save('user_sql');
//delete from `link_user` where `id` = '1';
```

change
------

[](#change)

```
$generate->change('user', function ($table) {
    $table->string('name', 50)->change();
    $table->integer('age', 11)->change();
});

//ALTER TABLE user CHANGE name name VARCHAR(50) CHARACTER SET utf8 DEFAULT '' NOT NULL COLLATE `utf8_general_ci`, CHANGE age age int(11) DEFAULT '0';
```

save or dump
------------

[](#save-or-dump)

```
# save
$generate->save($filename, $extension = 'sql'); // save to file

# dump
$generate->dump(); // print all sql
```

###  Health Score

20

—

LowBetter than 13% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity44

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

1051d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/e1d437156710565b6239dfd93b09c2293771f6d244bcb9345fb8942d192bdce5?d=identicon)[hogus2037](/maintainers/hogus2037)

### Embed Badge

![Health badge](/badges/hogus-generate-query-sql/health.svg)

```
[![Health](https://phpackages.com/badges/hogus-generate-query-sql/health.svg)](https://phpackages.com/packages/hogus-generate-query-sql)
```

###  Alternatives

[backpack/crud

Quickly build admin interfaces using Laravel, Bootstrap and JavaScript.

3.4k3.7M223](/packages/backpack-crud)[tpetry/laravel-postgresql-enhanced

Support for many missing PostgreSQL specific features

1.0k2.4M29](/packages/tpetry-laravel-postgresql-enhanced)[leantime/leantime

Open source project management system for non-project managers. Simple like Trello, powerful like Jira. Built with neurodiversity in mind.

10.2k3.5k](/packages/leantime-leantime)[anourvalar/eloquent-serialize

Laravel Query Builder (Eloquent) serialization

11223.5M33](/packages/anourvalar-eloquent-serialize)[statamic-rad-pack/runway

Eloquently manage your database models in Statamic.

135224.7k7](/packages/statamic-rad-pack-runway)[ronasit/laravel-entity-generator

Provided console command for generating entities.

2053.1k](/packages/ronasit-laravel-entity-generator)

PHPackages © 2026

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