Release note v1.5.2

roi.m

Release Notes

Version 1.5.2 (Latest)

Release Date: January 20, 2026
Commit Range: ecc9efd → e4c72d2

Overview

This release includes significant feature enhancements, security improvements, and infrastructure updates. The version has progressed from 1.4.3 to 1.5.2, introducing major new capabilities in query management, schema visualization, and version management.

Major Features

Query Console Enhancements

Saved Queries Functionality: New ability to save, manage, and reuse SQL queries
- Save queries with custom names and descriptions
- Browse and load saved queries from a dedicated dialog
- Enhanced query persistence and retrieval
Row Modification Handling: Dynamic UPDATE statement generation for query results
- Improved CRUD operations in Query Console
- Enhanced SQL query handling and logging

Schema Management

Schema Creation Prompt: New prompt in connection dialog to create schemas when needed
Foreign Key Enrichment: Enhanced schema graph visualization with JDBC foreign key relationships
- Improved schema graph retrieval with better error handling
- Enhanced metadata service capabilities

Hub Integration Improvements

Enhanced SQL Query Handling: Improved integration with Hub for asset creation
- Stored Procedure Support: Added support for CALL statements in SQL queries
- Procedure Name Extraction: Enhanced table/procedure name extraction from CALL statements with proper normalization
- Kebab-case Naming: Automatic kebab-case conversion for stored procedures with '-sp' suffix
- Schema Qualification: Updated query generation prompts to require schema qualification for table names
- CRUD Dialog Enhancements: Improved user experience with clearer labels (Operation name → Model name)
Enhanced Logging & Debugging: Comprehensive logging improvements in HubService
- Detailed logging for asset creation operations including input parameters and payload structure
- Enhanced error messages with full request/response context
- Better debugging information for Hub API interactions
Query Console Integration: Improved Query Console integration with Hub
- Enhanced WHERE clause condition management (AND to OR logic improvements)
- New methods for better condition management and grouping
- Added schemaName field to chat for improved context in query generation
- Better integration between Query Console and Hub asset creation workflows

Version Management

Version Display & Management: Complete version management system implementation
- Version displayed in application UI (title bar badge)
- Version API endpoint (/api/v1/version) for runtime version access
- Version information in startup logs and JAR manifest
- Automatic version reload on authentication state changes

Security Improvements

Dockerfile Enhancements

Removed Python packages to fix multiple CVEs:
- CVE-2018-20225, CVE-2025-8869, CVE-2023-5752 (pip)
- CVE-2025-47273, CVE-2024-6345, CVE-2022-40897 (setuptools)
Enhanced security configuration for production deployments

Dependency Updates & CVE Fixes

Netty: Updated to 4.1.129.Final (fixes CVE-2025-67735)
Protobuf: Updated to 3.25.5 (fixes CVE-2024-7254)
Dependency version management improvements in build.gradle.kts
Vert.x and Logback version adjustments for compatibility

️ Infrastructure & Developer Experience

Version Management Automation

Unified Version Bump Scripts: New tag-and-bump.sh script for streamlined version management
- Single script for version bumping and tagging
- Support for patch, minor, and major version increments
- Automatic synchronization between gradle.properties and frontend/package.json
Release Workflow Documentation: Comprehensive guides added
- RELEASE_WORKFLOW.md: CI/CD integration guide
- VERSIONING.md: Complete version management documentation

Statistics

Total Commits: 28 commits
Files Changed: 44 files
Lines Added: ~3,406 insertions
Lines Removed: ~246 deletions
Net Change: +3,160 lines

Key File Changes

Frontend: Query Console, Saved Queries components, Connection Dialog enhancements
Backend: Hub Service, Metadata Service, Query Service improvements
Infrastructure: Dockerfile, build configuration, version management scripts
Documentation: Release workflow, versioning guides

Version Progression

1.4.3 → 1.4.4: Version management infrastructure
1.4.4 → 1.4.6: Version bump script improvements
1.4.6 → 1.4.7: Foreign key enrichment
1.4.7 → 1.4.8: Schema creation prompt, version display enhancements
1.4.8 → 1.4.9: JSON parsing improvements
1.4.9 → 1.5.0: Saved queries functionality, Dockerfile security
1.5.0 → 1.5.1: Dependency compatibility adjustments
1.5.1 → 1.5.2: CVE fixes, final dependency updates

Notable Changes by Component

Frontend (`frontend/`)

New saved queries dialog components
Enhanced query console with save/load functionality
Improved connection dialog with schema creation prompt
Version badge in application header
Enhanced CRUD dialog components

Infrastructure

Dockerfile security hardening
Build configuration updates for CVE fixes
Version management scripts and documentation
Enhanced logging configuration

Migration Notes

Version Display: Version is now automatically displayed in the UI. No action required.
Saved Queries: New feature available immediately. Existing queries are not migrated automatically.
Dependencies: Ensure Docker images are rebuilt with the updated Dockerfile for security fixes.
Version Management: Teams can now use the new tag-and-bump.sh script for version management.

Related Pull Requests

PR #16: Schema graph foreign key enrichment

Note: This release represents a significant milestone with major feature additions, security improvements, and enhanced developer tooling. All users are encouraged to upgrade to benefit from the new features and security fixes.

OpenLegacy Community