Skip to content

NodeQL 0.3.0 – Visual SQL Workflows and Plugin SDK v2

Choose a tag to compare

View all tags
@github-actions github-actions released this 15 Jun 16:12
v0.3.00
3b25e81

NodeQL 0.3.0

This release substantially expands NodeQL as a visual, local-first SQL learning and development environment.

Highlights

  • Redesigned SQL blocks with syntax-specific shapes
  • Scratch-style nested column, text, and aggregate blocks
  • Improved SELECT, FROM, JOIN, WHERE, GROUP BY and ORDER BY workflows
  • Interactive seven-step onboarding tutorial
  • Plugin SDK v2 with external data-source adapters
  • Custom SHA-256-verified community plugin repositories
  • New White Mode
  • Responsive SQL command output
  • Maximized desktop startup

SQL Block Improvements

  • Added dedicated shapes for statements, clauses, JOINs, expressions, set operators and terminal blocks.
  • Added syntax-aware docking and SQL clause ordering.
  • Added rounded column and text reporter nodes.
  • Aggregate nodes such as AVG, COUNT, SUM, MIN and MAX accept nested reporters.
  • Restored reliable SELECT ... FROM ... generation.
  • Added table selectors directly to SELECT and JOIN blocks.
  • Fixed dropdown positioning and layout overlaps.
  • Added dynamic JOIN behavior:
    • INNER, LEFT, RIGHT, FULL and Self-Join use an ON condition.
    • CROSS and NATURAL JOINs do not display or compile an ON condition.
  • Added vertical separators that visually identify appended JOIN tables.

Plugin SDK v2

  • Added declarative HTTP data-source adapters.
  • Added permissions for network hosts and symbolic secrets.
  • Added support for contributor-maintained MongoDB, Supabase and other external bridges.
  • Added custom repository catalogs to the Plugin Dashboard.
  • Added HTTPS enforcement, size limits and SHA-256 manifest verification.
  • Added separate plugin statement, value and container shapes.
  • Existing Plugin SDK v1 manifests remain compatible.

User Experience

  • Added an interactive onboarding tutorial with exercises.
  • Added persistent White, Dark, Midnight and Matrix themes.
  • Redesigned the SQL output with a dedicated header and copy action.
  • Improved responsive SQL output sizing.
  • Desktop applications now start maximized on macOS, Windows and Linux.

Compatibility

Existing projects and Plugin SDK v1 manifests remain supported. Legacy SELECT projects receive a fallback when their separate FROM configuration is incomplete.

Validation

  • 68 automated tests passing
  • flutter analyze passes without issues
  • macOS release build verified successfully

What's Changed

  • Bump json_serializable, json_annotation, freezed_annotation, freezed and build_runner by @dependabot[bot] in #10
  • Bump window_manager from 0.4.3 to 0.5.1 by @dependabot[bot] in #8
  • Bump package_info_plus from 8.3.1 to 9.0.1 by @dependabot[bot] in #6
  • Bump actions/upload-pages-artifact from 3 to 5 by @dependabot[bot] in #5
  • Bump actions/upload-artifact from 4 to 7 by @dependabot[bot] in #4
  • Bump actions/checkout from 4 to 6 by @dependabot[bot] in #3
  • Bump actions/deploy-pages from 4 to 5 by @dependabot[bot] in #2
  • Bump actions/configure-pages from 5 to 6 by @dependabot[bot] in #1

New Contributors

Full Changelog: v0.2.00...v0.3.00

Contributors

dependabot
Assets 7
Loading