Download the PHP package finesse/query-scribe without Composer
On this page you can find all versions of the php package finesse/query-scribe. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download finesse/query-scribe
More information about finesse/query-scribe
Files in finesse/query-scribe
Package query-scribe
Short Description Light SQL query builder designed for extensibility and flexibility
License MIT
Homepage https://github.com/Finesse/QueryScribe
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package query-scribe
Query Scribe
Provides a convenient object syntax to build SQL queries. Compiles the queries to an SQL text with values for binding. Doesn't perform queries to database.
To perform compiled queries to a database, use a database connector like PDO, MicroDB or DBAL or use a ready database abstraction like MiniDB or Wired.
Key features:
- The builder has a single responsibility: build SQL.
- Designed for further extension. You may build a database tool or an ORM on top of it without major problems. Examples will come soon.
- Very flexible. You can pass a raw SQL or a subquery almost everywhere (see the PHPDoc comments in the code to know where you can pass them).
- Smart table prefixes which consider table aliases (don't work in raw expressions).
- All the values go to bindings, even from subqueries.
- No dependencies. Requires only PHP ≥ 7.
Supported SQL dialects:
- MySQL
- SQLite
SQL Server(not fully supported)- Maybe any other, didn't test it
If you need a dialect support please extend the CommonGrammar class and make a pull request.
Documentation
The documentation is available at queryscribe.readthedocs.io.
Also all the classes, methods and properties has a PHPDoc comment in the code.
Versions compatibility
The project follows the Semantic Versioning.
License
MIT. See the LICENSE file for details.
