v2.1 Road Map & Discussion

[kwhat]

Version 2.1 will be a backward compatible feature release of the 2.x branch. There will be a slight API adjustment to remove the DatabaseException class; this was done because throwing exceptions was not supported in __toString() until PHP 7.4. For example, if you echo any of the statements or clauses you will receive a fatal error instead of the expected exception. I have currently replaced the DatabaseException with trigger_error @ E_USER_ERROR. Comments on this issue, or any other comments / suggestions are welcome.

Issues and Changes

• ON DUPLICATE KEY UPDATE (insert update on duplicate key support. #86)
• CREATE / ALTER TABLE (Operations on tables: CREATE / ALTER TABLE or queries different to CRUD #30)
• Database drivers
  • SqlSrv (Limit clause with sql server #29)
  • Postgres (Update LimitClause doesn't use proper Postgres "OFFSET" syntax #47)
• Multiple insert values per statement (Can we use multiple insert statement in FaaPz / PDO #104 )