Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

OpenLegacy Community

  1. Home
  2. SQOL
  3. Release Notes v1.4.0

Release Notes v1.4.0

Scheduled Pinned Locked Moved SQOL
1 Posts 1 Posters 44 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • roi.mR Offline
    roi.mR Offline
    roi.m
    wrote on last edited by
    #1

    Release Notes

    Release Date: January 4, 2026
    Commit Range: 1fb65668be92f706fb3347e0b9aa78c24d4603dc to c0adef4


    🎯 High-Level Summary

    Query Console Enhancements

    Interactive Data Editing & Management

    • Direct cell editing in query results with inline editing for short values and dialog-based editing for long values
    • Visual tracking of modified rows with protected primary key columns
    • One-click UPDATE/DELETE statement generation with automatic WHERE clause creation using primary keys
    • Column sorting with type-aware ordering and automatic ORDER BY clause generation

    Database Schema Management

    Comprehensive Schema Tools

    • Stored procedures browser with metadata viewing and automatic CALL statement generation
    • Visual table designer for CREATE TABLE and ALTER TABLE operations with database-specific DDL generation
    • Interactive schema graph visualization showing tables, relationships, and foreign keys with pan/zoom capabilities

    Hub Integration & Settings

    Enhanced Hub Workflow

    • Personal Hub settings configuration with local storage and admin-controlled visibility
    • Collapsible SQL query editing panel with JDBC style conversion
    • Enhanced asset name suggestions based on SQL operations
    • Success dialogs with OL Hub URL display for created assets

    Query Chat & AI Features

    Intelligent Query Assistance

    • Prompt suggestions for data analysis and schema improvements
    • SQL query extraction from chat messages with direct execution capability
    • Schema optimization recommendations (normalization, indexing, partitioning)
    • Foreign key relationship analysis and referential integrity suggestions

    Connection & Admin Management

    Improved Configuration

    • Schema autocomplete in connection dialog with refresh functionality
    • Admin settings for Hub UI URL configuration
    • Enhanced tooltips and user guidance throughout the application
    • Tab management and conditional log visibility in admin panel

    Editor & UI Improvements

    Modern Development Experience

    • Monaco Editor integration for enhanced SQL editing with syntax highlighting
    • Improved visual styling and user feedback across components
    • Signal-based state management for better reactivity and synchronization

    1 Reply Last reply
    0

    Hello! It looks like you're interested in this conversation, but you don't have an account yet.

    Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

    With your input, this post could be even better 💗

    Register Login
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Login or register to search.
    Powered by NodeBB Contributors
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups