v.2.74.0
3 months ago by Craig Adam
New Features
- Parameterized Query Support: Added comprehensive support for parameterized queries using Nunjucks templates, enabling dynamic SQL execution with type-safe parameter binding
- AI-Powered Parameter Extraction: Implemented LLM-based automatic detection and extraction of query parameters with confidence scoring and metadata generation
- Enhanced Query Management UI: New Angular components for query creation, parameter management, and execution with real-time validation and preview capabilities
- QueryParameter Entity System: Complete CRUD operations for query parameters with validation filters, type checking, and sample values
- Smart Template Detection: Automatic detection of Nunjucks template markers in SQL with performance optimizations for parameter-enabled queries
Improvements
- Entity Metadata Enhancement: Added comprehensive descriptions for 100+ entities and 1000+ entity fields for better documentation and developer experience
- Query Form User Interface: Redesigned query editing experience with expandable sections, SQL syntax highlighting, and integrated parameter management
- MS Graph Email Integration: Enhanced MS Graph provider to automatically save sent emails in sender's sent items folder
- QueryResolver Performance: Optimized query resolution using metadata cache instead of entity loads for better performance
- SQL Parameter Processing: More flexible SQL parameter extraction allowing base table or view matching for improved entity lookups
Bug Fixes
- React Test Harness Context: Fixed contextUser parameter passing in test harness to ensure proper user context in server-side operations
- Query Metadata Refresh: Added automatic metadata refresh when queries are not found to handle cache invalidation scenarios
- Form Change Detection: Improved Angular form change detection to prevent expression changed errors during dynamic content updates