3.22.1

MagicObject Version 3.22.1

Bug Fixes

1. Empty Value in Insert Query

   Fixed a bug when generating INSERT queries with empty values.

   Previously, the generated query was:

   INSERT INTO any (any1, any2, any3) VALUES (1, , 'any3');

   Now it has been corrected to:

   INSERT INTO any (any1, any2, any3) VALUES (1, '', 'any3');

   This change ensures that empty values are properly handled as empty strings (''), resulting in valid SQL syntax and improved compatibility across different databases.

With this fix, MagicObject now handles optional or missing fields more reliably during insert operations.

What's Changed

• Update by @kamshory in #183
• Feature/3.22.1 by @kamshory in #184
• Update PicoDatabaseQueryBuilder.php by @kamshory in #185

Full Changelog: 3.22.0...3.22.1