v.2.74.0

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