Skip to content

Releases: francerz/php-sql-builder

Anniversary update 🎉

01 Nov 04:17

Choose a tag to compare

First year since the first release of SQL Builder: adding new features, improving performance and reducing coding work.

New Features:

  • Using doccomments @sql-key, @sql-ignore to selfdescribe atributes from objects on custom classes.
  • Allow select table in DELETE query when JOIN is applied using $query->rowsIn($tableAlias).
  • Using clear enumerations for Joins, Nests and Operators.
  • Added database detection in table parsing.
  • Added connection per query, allowing to nest from various servers.

Internal improvements:

  • Enforcing PSR-12 coding styles.
  • Simplified dependencies removing francerz/http and using only psr/http-message for UriInterface.
  • Improved documentation.
  • Added badges for stability status.

Deprecation:

  • Q class that extends from Query.
  • Various methods from Query which are shorthands like c (column), f (func), a (array), v (value), r (raw).

v0.2.49

12 Feb 17:58

Choose a tag to compare

Nest condition connectors translated to OR

v0.2.48

06 Feb 00:54

Choose a tag to compare

Added GroupBy to Select

v0.2.47

06 Feb 00:23

Choose a tag to compare

Supporting Upsert firstId when action is Update

v0.2.46

05 Feb 23:25

Choose a tag to compare

Exception includes values.

v0.2.45

03 Feb 18:29

Choose a tag to compare

Exits nesting and afterExecute when empty result.

v0.2.44

02 Feb 19:05

Choose a tag to compare

Added suport to null join columns

v0.2.43: Incremented upsert logic.

01 Feb 15:59

Choose a tag to compare

If bulk insert fails, then insert by row is performed.
If row insert failed, then update is performed.

v0.2.42

01 Feb 01:14

Choose a tag to compare

Update tests

v0.2.41

29 Jan 18:38

Choose a tag to compare

Added afterExecute actions for SelectQuery