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(3y ago)09MITPHP

Since Aug 17Pushed 3y 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 2w ago

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 12% 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

1097d 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.8M228](/packages/backpack-crud)[leantime/leantime

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

11.3k4.0k](/packages/leantime-leantime)[statamic-rad-pack/runway

Eloquently manage your database models in Statamic.

137236.2k8](/packages/statamic-rad-pack-runway)[dcat-plus/laravel-admin

dcat-plus admin

1494.6k10](/packages/dcat-plus-laravel-admin)[ronasit/laravel-helpers

Provided helpers function and some helper class.

2087.0k31](/packages/ronasit-laravel-helpers)[ronasit/laravel-entity-generator

Provided console command for generating entities.

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

PHPackages © 2026

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