NodeQL 0.3.4

NodeQL v0.3.4

This release delivers a refreshed interface, more personalization, and a more reliable project workflow.

Highlights

• Refreshed workbench UI with improved responsive layout
• New application icon across supported platforms
• Customizable themes and accent colors
• Localized block-palette categories
• Improved node help dialog styling
• More reliable restoration of the most recently used project on macOS
• Persistent access handling for recently opened project files
• Project upgrade dialog for supported legacy project formats
• Updated SQLite dependency and general stability improvements

Fixes

• Fixed issues when reopening projects after restarting the app
• Improved project autosave and project creation behavior
• Resolved smaller UI inconsistencies and analyzer warnings

Full Changelog: v0.3.3...v0.3.4

Thank you for using NodeQL!

NodeQL 0.3.3

NodeQL 0.3.3

This release improves project reliability and the visual SQL workspace.

Project files

• New projects now create their .nodeql file immediately.
• Existing file names are handled safely to prevent accidental overwrites.
• Save projects with Cmd+S on macOS or Ctrl+S on Windows and Linux.
• Autosave can be enabled individually when creating a project.
• Older supported NodeQL, ScratchQL, and workspace files can now be upgraded when opened.
• NodeQL creates a timestamped backup before upgrading a project file.
• Files created by a newer incompatible NodeQL version are protected from being overwritten.

Workspace

• Improved node sizing, label alignment, inline inputs, and palette previews.
• Long labels and values no longer clip as easily.
• JOIN nodes retain their specialized two-row layout.

Platform and documentation

• Removed obsolete CocoaPods integration from the macOS configuration.
• Added an English NodeQL architecture wiki.
• Updated build_runner to 2.15.1.

NodeQL 0.3.2

NodeQL 0.3.1

This release focuses on UI polish and macOS build cleanup.

Improved

• Refined block text alignment so node labels sit more naturally within their blocks.
• Adjusted Join node spacing for clearer two-line layouts.
• Simplified Join node visuals by removing extra guide-line decoration.
• Improved tutorial step navigation readability across themes.

macOS

• Removed legacy CocoaPods integration from the macOS project.
• Updated Flutter macOS xcconfig files to use Swift Package based plugin integration.
• Verified the macOS release build after the configuration cleanup.

What's Changed

• Bump actions/checkout from 6 to 7 by @dependabot[bot] in #18
• Bump go_router from 14.8.1 to 17.3.0 by @dependabot[bot] in #21
• Bump path_provider from 2.1.5 to 2.1.6 by @dependabot[bot] in #20
• Bump actions/download-artifact from 4 to 8 by @dependabot[bot] in #19
• Dev Change: Updated Dependabot to work on Dev Branch too by @Kartoffelspalt in #22
• Dev by @Kartoffelspalt in #26
• Dev by @Kartoffelspalt in #27

Full Changelog: v0.3.01...v0.3.2

NodeQL 0.3.1

NodeQL 0.3.1

This update primary fixes the Issue that the app crashes when you try to "Run SQL" when having a Sketch with more than 2 Joins.

What's Changed

• docs: add app gallery and improve White Mode tutorial by @Kartoffelspalt in #12
• Columns Dropdown now contains "Everything" as an option which is the … by @Kartoffelspalt in #13
• Codex/tutorial plugin docs by @Kartoffelspalt in #14
• fix: New Porject creation by @Kartoffelspalt in #15
• fix: Crash after Run SQL when having more than 1 Join after another by @Kartoffelspalt in #17

New Contributors

• @Kartoffelspalt made their first contribution in #12

Full Changelog: v0.3.00...v0.3.01

NodeQL 0.3.0 – Visual SQL Workflows and Plugin SDK v2

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

• @dependabot[bot] made their first contribution in #10

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

NodeQL 0.2.00 - First Public Preview

NodeQL 0.2.00 - First Public Preview

This is the first public preview release of NodeQL, a local-first visual SQL learning and development application.

Highlights

• Visual SQL workflow editor with block snapping and execution
• Local SQLite database support
• Project autosave and recent-project management
• Declarative and validated JSON plugin system
• Installable community translation packages
• Offline translation cache with English fallback
• Automatic GitHub release update checks
• Dark, Midnight, and Matrix themes

Supported Platforms

• Linux x64
• macOS Intel and Apple Silicon
• Windows x64

Web, Android, and iOS are not supported release targets in this preview.

Privacy

NodeQL does not include analytics, advertising, account tracking, or automatic crash reporting. Projects and databases remain on the user's device.

Security Notice

The macOS and Windows downloads are currently not signed with commercial platform certificates. Your operating system may display a security warning.

Release files include SHA-256 checksums in SHA256SUMS.txt.

Feedback

Please report reproducible bugs through GitHub Issues. Security vulnerabilities must be submitted using GitHub private vulnerability reporting.

Full Changelog: v0.1.33+33...v0.2.00

Version 0.1.33

NodeQL Plugin SDK v1

NodeQL now supports independent external plugins. Developers can create visual SQL blocks without modifying NodeQL or using Dart and Flutter.

Highlights

• Install and manage plugins through Settings > Manage Plugins
• Localized block names and descriptions
• Custom colors, inputs, and block shapes
• SQL expressions, statements, and container blocks
• Version and compatibility validation
• Warnings for missing plugins and version mismatches
• Secure declarative JSON format
• JSON Schema and developer documentation

Example Plugins

This release includes six example plugins with 22 blocks:

• Analytics Lab: rankings, running totals, and moving averages
• Data Quality Inspector: duplicate detection, NULL profiling, and range checks
• JSON Toolkit: extract, validate, inspect, and update JSON data
• Privacy Tools: email, phone, and generic value masking
• SQLite Power Pack: query plans, upserts, CTEs, and date series
• Text Tools: case-insensitive matching and transaction containers

Reliability and Security

Plugin references and version information are stored in NodeQL projects. If a required plugin is missing, NodeQL preserves the block data and displays a compiler warning.

Plugin SDK v1 uses a declarative execution model. It does not load third-party Dart code, native libraries, scripts, or executables.

Full Changelog: v0.1.32+32...v0.1.33+33

Version 0.1.32

Implement NodeQL app updates and desktop workflow fixes

• Rename ScratchQL/ScratchQL Creator references to NodeQL
• Add GitHub release update check on app startup
• Configure launcher icons from assets/appicon/icon.png
• Replace package identifiers with digital.codespiresolutions
• Preserve compatibility for opening legacy ScratchQL project files
• Fix workspace snapping so EXECUTE QUERY cannot be nested or chained above
• Improve delete handling for selected blocks and root chains
• Add macOS trackpad zoom/pan gesture handling
• Add native Projects/Edit menus on macOS and Windows
• Add Project > Save Project alongside Save Project As
• Allow selecting more than three columns while compacting UI display with “, ...”
• Add and update tests for update checks and workspace behavior

Full Changelog: v0.1.31+31...v0.1.32+32

NodeQL 0.1.31

NodeQL is a visual, Scratch-inspired SQL query builder that allows non-developers to construct database queries without syntax errors using drag-and-drop blocks.

Key Features

• Simple Mode: Visual block-based querying for quick data retrieval, filtering, and sorting without any coding knowledge.
• Advanced Mode: Extended block logic supporting complex operations (JOINs, GROUP BY, subqueries) along with a live SQL code preview.

Target Audience

• Non-Developers & Business Users (Product Managers, Analysts)
• Low-Code Users looking to accelerate workflows
• SQL Beginners learning relational database logic