FlameRobin Release 26.7.8 - Next-Gen Firebird Engine Features & Advanced Refactoring 🚀

We are excited to announce FlameRobin Release 26.7.8! This release introduces advanced refactoring utilities and GUI tools tailored for Next-Gen Firebird Engine developments and SQL:2023 compliance.

Highlights in Release 26.7.8

1. Interactive Schema DDL Generator & Qualified Object Refactoring 🏛️

• Visual Schema DDL Dialogs: Integrated CreateSchemaDialog supporting CREATE SCHEMA <name> [AUTHORIZATION <owner>] and ALTER SCHEMA <oldname> RENAME TO <newname> OWNER TO <owner> with real-time DDL statement preview.
• Automated Schema Qualification Engine: Added SchemaRefactoringHelper to automatically refactor unqualified object references (TABLE_NAME) into schema-qualified syntax (SCHEMA_NAME.TABLE_NAME) across views, triggers, and PSQL routines.
• Drop Schema Statement Generator: Supports DROP SCHEMA <name> [CASCADE | RESTRICT] statements.

2. JSON & Document Field Editor 📄

• Visual JSON Tree & Document Editor: Multiline JSON editor dialog (JsonFieldEditorDialog) equipped with Format JSON (pretty-printing) and Validate JSON syntax checks powered by nlohmann::json.
• Firebird 6 Native JSON Expression Builder: Interactive expression generator for Firebird 6 JSON constructs:
• JSON_VALUE(COLUMN, '$.path' RETURNING VARCHAR(255))
• JSON_QUERY(COLUMN, '$.path')
• JSON_EXISTS(COLUMN, '$.path')

3. Temporal Tables & System-Time Versioning ⏳

• System-Versioned Temporal Table DDL: Integrated TemporalTableDialog and TemporalTableHelper generating SQL-standard temporal table definitions:
• ALTER TABLE <table> ADD SYS_START TIMESTAMP WITH TIME ZONE GENERATED ALWAYS AS ROW START... ADD PERIOD FOR SYSTEM_TIME (SYS_START, SYS_END);
• Point-in-Time & Range Historical Query Generator:
• SELECT * FROM <table> FOR SYSTEM_TIME AS OF '<timestamp>'
• SELECT * FROM <table> FOR SYSTEM_TIME BETWEEN '<t1>' AND '<t2>'

4. MSVC Compatibility & Stability Fixes 🛠️

• Visual C++ Error C2445 Resolution: Resolved ternary type ambiguity in MainFrame.cpp for clean MSVC builds across Visual Studio 2022.

Downloads & Tags

• Git Tag: v26.7.8
• Full Release Changelog: Included in docs/fr_whatsnew.html
• Test Suite: 22/22 CTest unit tests passed (100%)