- Home
- Database Query Builders
- Aura.SqlQuery
On the recordRead 14 Nov 202614 facts
Aura.SqlQuery
On the record
- Database independence
- The builders are independent of a particular database connection library; the page recommends PDO generally.auraphp.com · read 14 Nov 2026
- Identifier quoting
- The query objects quote identifiers automatically in most cases.auraphp.com · read 14 Nov 2026
- Installation
- The library can be installed and autoloaded with Composer, or obtained as a release or repository clone.auraphp.com · read 14 Nov 2026
- Intended users
- Aura says its independent library packages can be used in any codebase.auraphp.com · read 14 Nov 2026
- Portable query mode
- Common query objects expose common methods to support writing database-portable applications.auraphp.com · read 14 Nov 2026
- Project structure
- Aura describes its library packages as self-contained and independent of other packages.auraphp.com · read 14 Nov 2026
- Purpose
- Aura.SqlQuery provides query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.auraphp.com · read 14 Nov 2026
- Query execution
- The query objects build queries but do not execute them; users pass the result to a database connection.auraphp.com · read 14 Nov 2026
- Query types
- The query factory can create SELECT, INSERT, UPDATE, and DELETE query objects.auraphp.com · read 14 Nov 2026
- Requirements
- The page says the library requires PHP 5.3.9 or later and has no userland dependencies.auraphp.com · read 14 Nov 2026
- Standards
- The library attempts to comply with PSR-1, PSR-2, and PSR-4.auraphp.com · read 14 Nov 2026
- Support
- The page directs users to the Aura community Google Group, Twitter account, or Freenode channel.auraphp.com · read 14 Nov 2026
- Supported connections
- PDO is used in the examples, and the page says other database libraries using named placeholders and bound values can work.auraphp.com · read 14 Nov 2026
- Testing
- The project documents running its PHPUnit tests from the command line with Composer installed.auraphp.com · read 14 Nov 2026