Release Date: May 2026
Release Type: Major Release
Branch: Current Production Release
New Features
SQL Text Masking for Query Logs
OneDB v2.2.0 introduces SQL text masking for Query Audit Logging.
This feature helps mask sensitive values inside captured SQL statements before they are stored in query logs.
This is useful when applications send sensitive information directly inside SQL text, such as:
- Identification numbers
- Account numbers
- Card numbers
- Phone numbers
- Other protected values
With this feature, OneDB can provide database activity visibility while reducing the risk of exposing sensitive information in audit records.
Improved DML Audit Logging
OneDB v2.2.0 improves audit logging support for data modification statements.
Supported DML operations include:
- INSERT
- UPDATE
- DELETE
- MERGE
This helps administrators review database activity more consistently across supported database platforms.
Enhancements
Query Log Normalization
This release improves SQL normalization before captured statements are stored in the audit log.
As a result, query logs become cleaner, easier to review, and more consistent across supported database environments.
Parser Stability Improvements
OneDB v2.2.0 includes parser stability improvements for complex and database-specific SQL statements.
This includes better handling for:
- Multi-line SQL
- Schema and table name extraction
- Protected field detection
- Vendor-specific DML syntax
Cross-Database Audit Handling
Query Audit Logging has been improved across supported database platforms, including PostgreSQL, MySQL, Oracle Database, and Microsoft SQL Server.
This helps provide more consistent audit behavior across different database environments.
Bug fixes
- Improved handling of SQL statements that contain protected values directly inside query text.
- Improved DML parsing behavior for audit logging.
- Improved SQL normalization before audit storage.
- Improved parser stability for database-specific SQL syntax.
- Improved protected field detection in captured SQL statements.
Security Updates
OneDB v2.2.0 improves audit log security by masking sensitive values inside captured SQL text before they are stored in query logs.
This helps reduce the risk of sensitive data exposure through database activity logs.
Known Notes
This release is recommended for deployments that use Query Audit Logging and need safer handling of sensitive values inside SQL statements.
Administrators should review Query Audit results after upgrade to ensure captured SQL text is displayed as expected for their application workload.
SQL text masking behavior depends on the configured protection policies and supported SQL parsing behavior for each database platform.
Summary
OneDB v2.2.0 is a feature release focused on safer Query Audit Logging.
This release introduces SQL text masking for query logs, improves DML audit handling for INSERT, UPDATE, DELETE, and MERGE operations, improves SQL normalization, and strengthens parser stability across supported database platforms.