packaged / querybuilder
Abstract Query Builder
Installs: 79 731
Dependents: 1
Suggesters: 0
Security: 0
Stars: 7
Watchers: 3
Forks: 0
Open Issues: 1
Requires
- php: >=7.4
- packaged/helpers: ^1.0||^2.0
Requires (Dev)
- phpunit/phpunit: ~8.0
- satooshi/php-coveralls: ~1.0.0
- dev-master
- 0.24.0
- 0.23.2
- 0.23.1
- 0.23.0
- 0.22.0
- 0.21.0
- 0.20.1
- 0.20.0
- 0.19.1
- 0.19.0
- 0.18.2
- 0.18.1
- 0.18.0
- 0.17.0
- 0.16.1
- 0.16.0
- 0.15.3
- 0.15.2
- 0.15.1
- 0.15.0
- 0.14.0
- 0.13.0
- 0.12.5
- 0.12.4
- 0.12.3
- 0.12.2
- 0.12.1
- 0.12.0
- 0.11.0
- 0.10.3
- 0.10.2
- 0.10.1
- 0.10.0
- 0.9.3
- 0.9.2
- 0.9.1
- 0.9.0
- 0.8.2
- 0.8.1
- 0.8.0
- 0.7.7
- 0.7.6
- 0.7.5
- 0.7.4
- 0.7.3
- 0.7.2
- 0.7.1
- 0.7.0
- 0.6.6
- 0.6.5
- 0.6.4
- 0.6.3
- 0.6.2
- 0.6.1
- 0.6.0
- 0.5.1
- 0.5.0
- 0.4.1
- 0.4.0
- 0.3.1
- 0.3.0
- 0.2.1
- 0.2.0
- 0.1.0
- dev-prepared-tuple
This package is auto-updated.
Last update: 2024-11-03 15:21:36 UTC
README
Reason
This library exists as a standalone query builder designed to split every single element of a query to allow packages using the library to convert the query into a more performant query, or supporting functionality not available in the original database layer.
Examples
CQL (Cassandra) does not support CONCAT, so this can be pulled from the original query, the fields gathered and then concatinated in PHP.
When running a sharded database, the query can be rebuilt to execute across multiple nodes with the correct partitioning keys, and then presented back to the user as a single result.
Terms
Base on information found on wikipedia - http://en.wikipedia.org/wiki/SQL
Clauses
Are constituent components of statements and queries.
Expressions
which can produce either scalar values, or tables consisting of columns and rows of data
Predicates
Specify conditions that can be evaluated to SQL three-valued logic (3VL) (true/false/unknown) or Boolean truth values and are used to limit the effects of statements and queries, or to change program flow.
Statements
May have a persistent effect on schemata and data, or may control transactions, program flow, connections, sessions, or diagnostics.
Query Statement
Retrieve data based on specific criteria.
Select Expression
Columns and Functions used to build the returning data