Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server in PHP.
Aura.SqlQuery is a PHP library that provides independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. It solves the problem of writing database-specific SQL queries by offering a flexible, decoupled approach that works with any database connection library, though PDO is recommended.
PHP developers who need to build SQL queries across multiple database systems without being tied to a specific database connection library or ORM.
Developers choose Aura.SqlQuery for its database-agnostic design and adherence to PHP standards (PSR-1, PSR-2, PSR-4), allowing integration into various projects while maintaining flexibility and compatibility.
Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides independent query builders for MySQL, PostgreSQL, SQLite, and SQL Server, enabling applications to switch databases without rewriting SQL logic, as highlighted in the README's feature list.
Decoupled from any specific database connection library, though PDO is recommended, allowing flexibility to use various connection methods without vendor lock-in.
Adheres to PSR-1, PSR-2, and PSR-4 coding standards, ensuring clean code and seamless integration into PSR-compliant PHP projects, as stated in the documentation.
Depends only on external interfaces, not implementations, promoting flexibility and compliance with community standards without forcing specific libraries, per the philosophy section.
Follows semantic versioning for stable and predictable updates, reducing the risk of unexpected breaking changes in production environments.
Lacks object-relational mapping features, so developers must manually handle result set to object conversion, which can be time-consuming for complex data models compared to full ORMs.
Does not enforce parameter binding or automatic sanitization; users must ensure secure practices when constructing queries, increasing the risk of SQL injection if not handled carefully.
Not natively integrated with popular PHP frameworks, requiring additional setup and potential compatibility issues when used in projects like Laravel or Symfony.
Constructing advanced queries such as multiple joins or subqueries can be more code-intensive and less intuitive compared to higher-level abstractions found in ORMs or framework-specific builders.