A PHP SQL query builder using PDO
Please use this release in your projects. All tests are passing, and we do not foresee any major problems. Issues will be resolved quickly. Our goal is to release 2.0.0 and have it production ready in 1 week.
Major Changes
Features
->select(null)
!!! You can now select individual columns by specifying an overwrite request: $fluent->from('table')->select('table.id', true)
->where('1')
Code Improvements
Base::execute()
Miscellaneous
Features
.
) and colons (:
) can now be escaped with a backslash (\
) to prevent a smart join on a statement! This is helpful if you don't want to disable smart joining entirely. In addition, Fluent will remove the backslashes for you before running the final query.Miscellaneous
Features
OR
statements in WHERE
clauses are now supported!Update::set()
where()
will now build correctly (id IN (?, ?, ?) -> [1, 2, 3]
)Code Improvements
WHERE
now has its own method for query buildingMiscellaneous
Major Changes
Features
Code Improvements
Miscellaneous
Bug Fixes Add PHP 7.2 functionality by ensuring counting is performed only on Countable data. (#240)
Major Changes
Code Improvements
Miscellaneous
The following changes have been made to this release:
Bug Fixes
FluentUtils::FormatQuery()
no longer accidentally splits words that are not keywords (ALEJ AND RO)FluentLiteral
in where()
statements are now taken literally (#213)Code Improvements
E_USER_ERROR
is now thrown when __call()
does not recognize the method name (to prevent typos from going unnoticed) (#214)SET
, OUTER
and FULL
are now classified as keywordsMiscellaneous