PHPackages aura/sqlquery - 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. aura/sqlquery ActiveLibrary[Database & ORM](/categories/database) aura/sqlquery ============= Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library. 3.0.0(3y ago)4572.9M—3.9%87[22 issues](https://github.com/auraphp/Aura.SqlQuery/issues)[3 PRs](https://github.com/auraphp/Aura.SqlQuery/pulls)20MITPHPPHP >=5.6CI passing Since Jan 7Pushed 4mo ago33 watchersCompare [ Source](https://github.com/auraphp/Aura.SqlQuery)[ Packagist](https://packagist.org/packages/aura/sqlquery)[ Docs](https://github.com/auraphp/Aura.SqlQuery)[ RSS](/packages/aura-sqlquery/feed)WikiDiscussions 3.x Synced 1mo ago READMEChangelog (10)Dependencies (1)Versions (20)Used By (20) Aura.SqlQuery ============= [](#aurasqlquery) Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although [PDO](http://php.net/PDO) in general is recommended. Installation and Autoloading ---------------------------- [](#installation-and-autoloading) This package is installable and PSR-4 autoloadable via Composer as [aura/sqlquery](https://packagist.org/packages/aura/sqlquery). Alternatively, [download a release](https://github.com/auraphp/Aura.SqlQuery/releases), or clone this repository, then map the `Aura\SqlQuery\` namespace to the package `src/` directory. Dependencies ------------ [](#dependencies) This package requires PHP 5.6 or later; it has been tested on PHP 5.6-8.5. We recommend using the latest available version of PHP as a matter of principle. Aura library packages may sometimes depend on external interfaces, but never on external implementations. This allows compliance with community standards without compromising flexibility. For specifics, please examine the package [composer.json](./composer.json) file. Quality ------- [](#quality) [![Scrutinizer Code Quality](https://camo.githubusercontent.com/59d3805a0595fb79bd6ce357edca15071c17d2bf25d43da36afde1cc512e75dc/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f617572617068702f417572612e53716c51756572792f6261646765732f7175616c6974792d73636f72652e706e673f623d332e78)](https://scrutinizer-ci.com/g/auraphp/Aura.SqlQuery/)[![codecov](https://camo.githubusercontent.com/56322946a7411eee2ac276aa589aa7f6321bee6bad3461c986556f543e9086a5/68747470733a2f2f636f6465636f762e696f2f67682f617572617068702f417572612e53716c51756572792f6272616e63682f332e782f67726170682f62616467652e7376673f746f6b656e3d554153446f754c787963)](https://codecov.io/gh/auraphp/Aura.SqlQuery)[![Continuous Integration](https://github.com/auraphp/Aura.SqlQuery/actions/workflows/continuous-integration.yml/badge.svg?branch=3.x)](https://github.com/auraphp/Aura.SqlQuery/actions/workflows/continuous-integration.yml) This project adheres to [Semantic Versioning](http://semver.org/). To run the unit tests at the command line, issue `composer install` and then `./vendor/bin/phpunit` at the package root. This requires [Composer](http://getcomposer.org/) to be available as `composer`. This package attempts to comply with [PSR-1](https://github.com/php-fig/fig-standards/blob/master/accepted/PSR-1-basic-coding-standard.md), [PSR-2](https://github.com/php-fig/fig-standards/blob/master/accepted/PSR-2-coding-style-guide.md), and [PSR-4](https://github.com/php-fig/fig-standards/blob/master/accepted/PSR-4-autoloader.md). If you notice compliance oversights, please send a patch via pull request. Community --------- [](#community) To ask questions, provide feedback, or otherwise communicate with other Aura users, please join our [Google Group](http://groups.google.com/group/auraphp), follow [@auraphp](http://twitter.com/auraphp), or chat with us on Freenode in the #auraphp channel. Documentation ------------- [](#documentation) This package is fully documented [here](./docs/index.md). ### Health Score 58 — FairBetter than 98% of packages Maintenance49 Moderate activity, may be stable Popularity63 Solid adoption and visibility Community46 Growing community involvement Maturity67 Established project with proven stability Bus Factor3 3 contributors hold 50%+ of commits 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 Every ~242 days Total 19 Last Release 145d ago Major Versions 2.7.1 → 3.0.0-alpha.12022-05-11 2.8.0 → 4.x-dev2023-04-25 2.8.1 → 3.x-dev2025-12-24 PHP version history (5 changes)2.0.0-beta1PHP >=5.4.0 2.0.0PHP >=5.3.0 2.7.0PHP >=5.3.9 3.0.0-alpha.1PHP >=5.6 4.x-devPHP ^7.2 || ^7.3 || ^7.4 || ^8.0 || ^8.1 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/25754?v=4)[Paul M. Jones](/maintainers/pmjones)[@pmjones](https://github.com/pmjones) ![](https://www.gravatar.com/avatar/29dba0e6add8d89fd3fc6126b213d5d2f57538ea78318963025d6ea98db34161?d=identicon)[harikt](/maintainers/harikt) --- Top Contributors [![harikt](https://avatars.githubusercontent.com/u/120454?v=4)](https://github.com/harikt "harikt (52 commits)")[![MAXakaWIZARD](https://avatars.githubusercontent.com/u/1138453?v=4)](https://github.com/MAXakaWIZARD "MAXakaWIZARD (31 commits)")[![koriym](https://avatars.githubusercontent.com/u/529021?v=4)](https://github.com/koriym "koriym (27 commits)")[![pavarnos](https://avatars.githubusercontent.com/u/589595?v=4)](https://github.com/pavarnos "pavarnos (20 commits)")[![mindplay-dk](https://avatars.githubusercontent.com/u/103348?v=4)](https://github.com/mindplay-dk "mindplay-dk (12 commits)")[![kornrunner](https://avatars.githubusercontent.com/u/725986?v=4)](https://github.com/kornrunner "kornrunner (7 commits)")[![pmjones](https://avatars.githubusercontent.com/u/25754?v=4)](https://github.com/pmjones "pmjones (6 commits)")[![rotexdegba](https://avatars.githubusercontent.com/u/1242622?v=4)](https://github.com/rotexdegba "rotexdegba (4 commits)")[![nyamsprod](https://avatars.githubusercontent.com/u/51073?v=4)](https://github.com/nyamsprod "nyamsprod (4 commits)")[![email-yuye](https://avatars.githubusercontent.com/u/175289169?v=4)](https://github.com/email-yuye "email-yuye (3 commits)")[![cammytown](https://avatars.githubusercontent.com/u/735509?v=4)](https://github.com/cammytown "cammytown (3 commits)")[![cxj](https://avatars.githubusercontent.com/u/446131?v=4)](https://github.com/cxj "cxj (3 commits)")[![jakejohns](https://avatars.githubusercontent.com/u/174708?v=4)](https://github.com/jakejohns "jakejohns (2 commits)")[![elazar](https://avatars.githubusercontent.com/u/15487?v=4)](https://github.com/elazar "elazar (2 commits)")[![ramirovarandas](https://avatars.githubusercontent.com/u/15105992?v=4)](https://github.com/ramirovarandas "ramirovarandas (2 commits)")[![Grummfy](https://avatars.githubusercontent.com/u/668804?v=4)](https://github.com/Grummfy "Grummfy (2 commits)")[![djmattyg007](https://avatars.githubusercontent.com/u/489338?v=4)](https://github.com/djmattyg007 "djmattyg007 (2 commits)")[![tamakiii](https://avatars.githubusercontent.com/u/264325?v=4)](https://github.com/tamakiii "tamakiii (1 commits)")[![afilina](https://avatars.githubusercontent.com/u/199835?v=4)](https://github.com/afilina "afilina (1 commits)")[![arabcoders](https://avatars.githubusercontent.com/u/1621552?v=4)](https://github.com/arabcoders "arabcoders (1 commits)") --- Tags microsoft-sql-servermysqlphppostgresqlquery-buildersqlitedatabasemysqlsqlitepostgresqlpostgressqlpdopgsqlsqlserverquerydbselectsql serverupdatedeleteinsertdml ### Embed Badge ![Health badge](/badges/aura-sqlquery/health.svg) ``` [![Health](https://phpackages.com/badges/aura-sqlquery/health.svg)](https://phpackages.com/packages/aura-sqlquery) ``` ### Alternatives [atlas/query Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer. 41249.0k7](/packages/atlas-query)[doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k578.4M5.6k](/packages/doctrine-dbal)[aura/sqlschema Provides facilities to read table names and table columns from a database using PDO. 41234.1k4](/packages/aura-sqlschema)[aura/sql A PDO extension that provides lazy connections, array quoting, query profiling, value binding, and convenience methods for common fetch styles. Because it extends PDO, existing code that uses PDO can use this without any changes to the existing code. 5632.5M43](/packages/aura-sql)[delight-im/db Safe and convenient SQL database access in a driver-agnostic way 49156.8k7](/packages/delight-im-db)[bentools/where PHP7.1 Fluent, immutable SQL query builder. Connectionless, framework-agnostic, no dependency. 125.2k2](/packages/bentools-where) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)