qbit-sql-workbench 1.0.0-RC.4

qbit-sql-workbench 1.0.0-RC.4 is published to Maven Central (com.kingsrook.qbits:qbit-sql-workbench:1.0.0-RC.4) from release/1.0 (CircleCI 40) on 2026-10-12. It requires QQQ 4.1.0-RC.4 or later and a Next UI that renders the SQL_WORKBENCH widget (v1.0.0-RC.13 or later; the record developer panel needs the developer view, from Next RC.15). Owner approval 2026-10-12: "all approved and releases approved". This is a prerelease.

Version note: 1.0.0-RC.3 on Maven Central is an accidental republish of the RC.2 code by an RC-tag build; do not use it. This candidate, RC.4, carries the changes the changelog lists under 1.0.0-RC.3. RC tags no longer trigger publishes (#15).

The signed annotated tag v1.0.0-RC.4 fixes source a0e3c22 (the orb's version bump on the merge of develop into release/1.0).

Included: #7 snake_case QQQ names with the sql_workbench_ prefix (breaking; see UPGRADE.md), #9 app home dashboard, Runner nav entry and main-tables-only nav, #6 record developer panel (links open SQL in the Runner), #14 record-screen polish. Not included: #16 (result-snapshot insert permission for users under core enforcement) follows in the next candidate.

Notes from the changelog:

Added

• App home dashboard. The sqlWorkbench app's home is now an information dashboard of real data, read in the viewer's session (permissions and record locks apply): summary tiles and links, runs per day, recent notebooks, recent runs, slowest and failed queries, most-used notebooks, shared notebooks, committed writes, and (workbench admins only) activity by user. Each widget has an honest empty state.
• Runner. The notebook editor (SQL_WORKBENCH widget) moves to its own nav entry: the sqlWorkbenchRunner child app, labeled Runner. Open a notebook with /app/sqlWorkbenchRunner?notebook=<id>.
• On a notebook's record view: an Open in Runner widget, and a Runs child list (its executions the viewer may see) through the new join sql_workbench_notebook_join_sql_workbench_execution.
• SqlWorkbenchIntegrations: opt-in ESB (esbTableNames) and Quick Search (quickSearchTables) hooks for the main tables, with no dependency on either module.
• Record developer panel "SQL Workbench" (SqlWorkbenchDeveloperPanelProvider, registered by SqlWorkbenchDeveloperPanelsMetaDataProducer): read-only SELECTs for the record and its table in the backend's own names, backend details, and links that open them in the Runner as a new cell (/app/sqlWorkbenchRunner?sql=&backend=, never run). Requires QQQ 4.1.0-RC.4 (the developer panel contract) and a Next UI with the Runner ?sql= support.

Changed

• The nav lists only the main tables: Notebooks and the execution audit, after the Runner. Cells, versions, pinned results and shares are child lists on a notebook (still standard tables, reachable by URL and API). The app's widget list is now the dashboard, not the SQL_WORKBENCH widget; links to /app/sqlWorkbench that expected the editor should point at /app/sqlWorkbenchRunner.
• The notebook record's header shows the description.
• Names follow the owner rule: lowercase snake_case, prefixed with the qbit's name (metadata only, no DDL). Tables sql_workbench_notebook, sql_workbench_cell, sql_workbench_notebook_version, sql_workbench_result_snapshot, sql_workbench_notebook_share, sql_workbench_execution (they now equal their backend table names); possible-value source sql_workbench_share_audience_type; permissions sql_workbench.*, sql_workbench_admin.hasAccess and <table>.read etc.; security key types sql_workbench_user (all-access sql_workbench_all_access) and sql_workbench_audience; joins sql_workbench_notebook_join_sql_workbench_*.
• tableNamePrefix (and the QBit namespace) is normalized to lowercase snake_case and joined with one _.

Deprecated

• LEGACY_TABLE_NAME on each entity, ShareAudienceType.LEGACY_NAME and SqlWorkbenchQBitConfig.LEGACY_* hold the pre-RC.3 names, for migrating stored references only.

Upgrade from RC.2

• Follow UPGRADE.md: grant the renamed permissions and rename stored table names (audit, saved views and reports). No DDL.