Aura.SqlQuery
Aura.SqlQuery: A PHP library for composing parameterized SQL across four database dialects. Ranked #45 of 51 in Database Query Builders by our editors (4.5/10); pricing: Free plan; best for PHP developers building parameterized SQL statements.
At a glance
- Editor score4.5 / 10
- PricingFree plan
- Best forPHP developers building parameterized SQL statements
- Free planYes
- Paid fromNone
- Facts checked4 Oct 2026
Where it wins
- Builds SELECT, INSERT, UPDATE and DELETE statements with bound values
- Supports bulk inserts and database-specific query methods
- Separates generated SQL and bound values from connection-library execution
Where it doesn't
- Does not execute statements; applications need a separate connection library
- Support is community-based
- No asynchronous query execution
Our verdict on Aura.SqlQuery
Aura.SqlQuery is an open-source PHP library for constructing SQL statements without binding query building to a particular database connection library. It provides query objects for SELECT, INSERT, UPDATE and DELETE operations, and supports MySQL, PostgreSQL, SQLite and Microsoft SQL Server. PHP developers who want to compose parameterized statements separately from database access are its clearest fit; it is not a standalone database client or query runner.
Its core workflow is to generate a statement and its bound values separately, then pass both to a chosen connection library such as PDO. Placeholders and bound values help keep query construction distinct from the values supplied at execution time, and bulk inserts can be built with multiple rows. The library also includes dialect-specific methods: MySQL and SQLite query methods, PostgreSQL RETURNING methods, and SQL Server LIMIT and OFFSET translation. This breadth is useful when an application targets multiple SQL dialects, though the actual execution remains outside Aura.SqlQuery.
The package is distributed as open-source software, has a free plan, and is installed through Composer. It is self-hosted and supports Linux, macOS and Windows. There is no asynchronous query execution, so teams seeking a library that manages database connections or runs queries asynchronously should look elsewhere. Community support is the listed support channel. Choose Aura.SqlQuery when the need is focused SQL construction in PHP and the application already has, or will provide, its own connection layer; choose a more execution-oriented tool if query running and connection management are part of the requirement.
Your product? Our editors can test Aura.SqlQuery in depth and publish a review, labelled as paid · from $99/mo →
Aura.SqlQuery pricing
Aura.SqlQuery fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | PHP |
| SQL dialects | MySQL, PostgreSQL, SQLite, Microsoft SQL Server |
| Type safety | Not verified |
| Async queries | No |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Deployment | Self-hosted |
| Platforms | Linux, macOS, Windows |
| Support | Community |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 1 integrations: PDO |
| Pricing | Free plan |
| Website | auraphp.com |
| Facts checked | 4 Oct 2026 |
Aura.SqlQuery integrations
Aura.SqlQuery lists 1 integrations on its own site.
- PDO
Alternatives to Aura.SqlQuery
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
See all Aura.SqlQuery alternatives →
Used Aura.SqlQuery? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Aura.SqlQuery for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Aura.SqlQuery is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/aura-sqlquery/"><img src="https://www.itechguides.com/best/badge/aura-sqlquery.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update