PHPackages                             lumiza/buildsql - 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. lumiza/buildsql

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

lumiza/buildsql
===============

Construct SQL statement of operation database without configuring database information

v1.0(7y ago)012MITPHPPHP >=5.5.0

Since Jan 28Pushed 7y agoCompare

[ Source](https://github.com/lumiza/buildsql)[ Packagist](https://packagist.org/packages/lumiza/buildsql)[ Docs](https://github.com/lumiza/buildsql)[ RSS](/packages/lumiza-buildsql/feed)WikiDiscussions master Synced 2mo ago

READMEChangelog (1)DependenciesVersions (2)Used By (0)

SQL statement for constructing operation database \[ CURD \]
------------------------------------------------------------

[](#sql-statement-for-constructing-operation-database--curd-)

Author: Rumble Url:

### About Language

[](#about-language)

- Chinese Readme File: CHINESE.md

### Package Install

[](#package-install)

- `composer require lumiza/buildsql`

### Development purpose

[](#development-purpose)

- Because many SQL build classes need to establish MySQL connections, but sometimes we just want SQL statements, do not want to connect to the database, so it is particularly important to have a pure SQL build tool.
- Current SQL building tools are based on ThinkPHP 3.2, and most SQL operations are the same as ThinkPHP 3.2 model operations.

### Instructions

[](#instructions)

- Using this tool, you do not need to configure any database information, and you will not establish MySQL connections.
- The Sql class supports the singleton creation of objects `Sql:: getInstance ();`, or directly `new Sql ()`.
- For detailed instructions, see `demo.php`, or ThinkPHP 3.2 operation model instructions

### Unsupported Operations

[](#unsupported-operations)

- Validation of database fields is not supported. \[ Table structure information cannot be obtained without establishing MySQL connections, and therefore cannot be validated \]
- Objects are not supported to create new data objects, that is, there is no `create` method, only in the form of arrays.
- The `cache` method in coherent operations is not supported.
- Calling the `field`method before the `add` method does not support field filtering.
- Calling the `field`method before the `save` method does not support field filtering, but does support data filtering.
- Deleting data does not support `sql-> delete ('1,2,5'); `This usage means that the `delete`method cannot take parameters
- The `select` function does not support parameters
- Mapping tables to classes and records to objects is not supported
- Field mapping is not supported
- The `relation` method in coherent operations is not supported

### Special Thanks

[](#special-thanks)

- Thank you for thinkphp's open source

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity5

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity55

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

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

2664d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/3293c38af83c107638ea2f9ef2507aff9b363b94e6474e3a911d71a543250522?d=identicon)[LuMiza](/maintainers/LuMiza)

---

Top Contributors

[![lumiza](https://avatars.githubusercontent.com/u/40270644?v=4)](https://github.com/lumiza "lumiza (1 commits)")

---

Tags

sqlbuild sqlphp mysql sql

### Embed Badge

![Health badge](/badges/lumiza-buildsql/health.svg)

```
[![Health](https://phpackages.com/badges/lumiza-buildsql/health.svg)](https://phpackages.com/packages/lumiza-buildsql)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[doctrine/sql-formatter

a PHP SQL highlighting library

1.9k166.0M85](/packages/doctrine-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[catfan/medoo

The lightweight PHP database framework to accelerate development

4.9k1.5M194](/packages/catfan-medoo)[phpmyadmin/sql-parser

A validating SQL lexer and parser with a focus on MySQL dialect.

47750.4M55](/packages/phpmyadmin-sql-parser)

PHPackages © 2026

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