auraphp/Aura.SqlQuery
Stars: 440
Forks: 81
Pull Requests: 112
Issues: 96
Watchers: 36
Last Updated: 2023-06-02 10:44:13
Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
License: MIT License
Languages: PHP
Aura.SqlQuery
Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although PDO in general is recommended.
Installation and Autoloading
This package is installable and PSR-4 autoloadable via Composer as aura/sqlquery.
Alternatively, download a release, or clone this repository, then map
the Aura\SqlQuery\ namespace to the package src/ directory.
Dependencies
This package requires PHP 5.6 or later; it has been tested on PHP 5.6-8.1. 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 file.
Quality
This project adheres to Semantic Versioning.
To run the unit tests at the command line, issue composer install and then
./vendor/bin/phpunit at the package root. This requires Composer to be
available as composer.
This package attempts to comply with PSR-1, PSR-2, and PSR-4. If you notice compliance oversights, please send a patch via pull request.
Community
To ask questions, provide feedback, or otherwise communicate with other Aura users, please join our Google Group, follow @auraphp, or chat with us on Freenode in the #auraphp channel.
Documentation
This package is fully documented here.
OPEN ISSUES
See all- INSERT | onDuplicateKeyUpdateCols doesn't add bindvalues to getBindValues() by @Altegras
- Upsert by @cdekok
- CTEs by @mathroc
- Common InsertTest class tests undocumented use case by @djmattyg007
- How to create 'where exists' queries? by @cdarken
- Insert with no data by @vlakarados
- Change exeption hierarchy for Aura Exception to LogicException or RuntimeException by @tored
- Postgres Lateral Join by @dextervip
- Quoting problem with cast() on postgres by @inghamn
- Idea: Parity across database models by @designermonkey
- Cannot use FROM with multiple table names by @designermonkey
- Improve IN statement for 3.0 release by @syrm
- Placeholder triples for where() and having() clauses by @dc2xl
- how can i add concat in select by @majidkm11
- To add IGNORE statement to INSERT query library has different interfaces by @maximTarleckiy
- Update '->where' method with binding params don't working by @FAST-JE
- # in column name by @otelconsulting
- Where with parentheses by @designermonkey
- Allow passing query to `union()` by @RentecTravis
- how to execute a query using: USE INDEX? by @suvarivaza
- Named placeholder don't work in where() by @gugglegum