UnSQL (v2.4)

• Aggregate Window - aggregate wrappers sum count avg min max now have over property for advanced window queries
• Enhance Upsert - arithmetic operations in upsert now use table prefix
• Atomic Transactions - all queries now use atomic transactions, unless Session Manager is used for transaction lifecycle hooks
• Faster Execution - internal code optimization to result in roughly 10-15% faster query generation
• Session Manager stabilized - handled transaction lifecycle exceptions
• New Rank Window Functions - rank denseRank percentRank rowNum nTile added to built-in wrapper objects
• New Value Window Functions - firstValue lastValue nthValue added to built-in wrapper objects
• New Offset Window Functions - lead lag added to built-in wrapper objects
• Standardized ifNull property - IFNULL / ISNULL replaced with dialect agnostic COALESCE
• ifNull support in sub-query - ifNull support added to refer and json wrappers

UnSQL (v2.3)

UnSQL is now even more stable and faster than before:

• New documentation style for more example based explanations instead of interface based explanations,
• new debug mode added: 'sandbox' to debug generated sql without executing them on database,
• encryption functionality added to upsert,
• new expressions based operations support added to upsert object,
• new upsert functionality created,
• new advanced sort functionality created with 'using' array for expressions and derived columns support added,
• save method re-written from scratch to be more abstract at the same time support more functionality,
• conditional key checks for 'where', 'having' etc optimized for faster iterations,
• new way to handle json created during insert,
• encryption feature added to bulk upload,
• new bulk upsert feature created,
• conditions map trimmed to remove unncessary whitespaces in the query,
• encryption override to match the set encryption removed (was running on every execution),
• encryption/decryption helpers re-written for optimized behaviour,
• junction dropped from the where and having blocks in favor of newer and better and and or wrappers

UnSQL (v2.1)

UnSQL v2.1 is yet another big release, as it consists stable support for multiple dialects of structured (SQL) databases viz. MySQL, PostgreSQL and SQLite

This release is packed with the following updates:

• Multi-Dialect Support UnSQL can now communicate with MySQL, PostgreSQL and SQLite
• Single Codebase while switching dialects, code does not need alterations (Except for Raw Queries)
• Bug fixes UnSQL gets more stability
• Raw Queries are now supported via. rawQuery method
• Code Optimization for performance enhancements
• Null safe fallback values for aggregate wrappers is added via. 'ifNull' property

UnSQL (v2.0)

Long awaited UnSQL (v2.0) is now published as production ready moved to stable release

Following changes were made:

• Built-in AES Encryption/Decryption modes: Protect sensitive data natively without any third part package
• Dynamic Query Generation: Prevent SQL injection using placeholders
• Multiple Debug modes: Debug the Dynamically generated query or run Execution Benchmark
• Built-in Error Handling: No more try-catch, result holds it all
• Revamped Interface: Now uses object based params and properties for interaction
• Evolved IntelliSense Support: JSDoc-compatible type definitions provide better IDE support (Code suggestions) and type checking

UnSQL (v2.0-Beta)

UnSQL version v2.0-beta with all new features and enhanced built-in security is now available in default import.