Flamerobin Roadmap Milestone Completed 🎉

 ### Implementation Completed: SQL Schemas (Firebird 6.0 / ODS 14) & Roadmap Completion

  The SQL Schemas metadata support has been fully implemented, verified across compilation and 19 unit tests (100% pass), and pushed to git master.

  ──────

  ### Key Capabilities Implemented

  1. First-Class Metadata Tree Container:

      • Created Schema and Schemas metadata classes (src/metadata/schema.h, src/metadata/schema.cpp) to represent SQL schemas in the FlameRobin metadata tree.

      • Automatically queries system table RDB$SCHEMAS (RDB$SCHEMA_NAME, RDB$OWNER_NAME, RDB$DESCRIPTION) when connected to a Firebird 6.0+ database (isFB60OrHigher()).

  2. Visitor & Engine Integration:

      • Added visitSchema and visitSchemas methods to MetadataItemVisitor.

      • Exposed getSchemas() on Database and integrated SchemasPtr into metadata collection initialization and lookup routines.

  ──────

  ### Roadmap Milestone Completed 🎉

  With the completion of SQL Schemas, all roadmap items across all phases of the FlameRobin Development Plan have been successfully completed and pushed:

  • Phase 1: Foundation & Build System (C++20, vcpkg, fb-cpp, DAL interfaces, CMake) — Completed

  • Phase 2: Metadata & Core Refactoring (DAL refactoring, DECFLOAT/INT128, Timezone API) — Completed

  • Phase 3: SQL Editor & UI Integration (DAL execution engine, DataGrid, Async Services) — Completed

  • Phase 4: Finalization & Performance (fb-cpp default backend, optimization) — Completed

  • Phase 5: Firebird 4.0 Feature Support (63-char identifiers, named timezones, DecFloat/Int128 DDL, replication) — Completed

  • Phase 6: Firebird 5.0 Feature Support (Partial indexes, parallel operations, SKIP LOCKED, LATERAL joins, multi-row RETURNING, profiler, MON$ cache) — Completed

  • Phase 7: Firebird 6.0 Feature Support (SQL Schemas, JSON functions, tablespaces, EXPLAIN, named arguments, GREATEST/LEAST, UNLIST, ANY_VALUE, ROW type, underscores in numeric literals, collation as data type property, string max lengths, CSV external tables, database owner) — Completed

  • Phase 8: IDE & SQL Experience Enhancements (Script as DDL/DML, multi-format export, client-side result filtering, environment color coding, quick connection switcher, visual execution plan, database schema comparison & migration generator, expanded MCP server) — Completed

  • Phase 9: PostgreSQL-Inspired Developer Tools & Monitoring (Live Session & Lock Monitor, routine parameter helper, maintenance & health dashboard, query execution statistics & buffer metrics, wire encryption status, interactive routine executor, session MCP tools) — Completed

  • Cross-Cutting Work (ODS version detection, keyword-set selection, system table query audit, SVG icon system, documentation, memory leak detection roadmap) — Completed

  ──────