🚀 July + August 2024 Product Updates

August 31, 2024

Federated queries without having to build your own infrastructure, Python workflows, MongoDB support, a new approach to sharing queries, smoother onboarding, and API changes to prepare for our upcoming desktop client. Here's everything that shipped across the last two months! 🚀

Built-in Federated Queries New

Federated queries allow you to query across multiple databases and database types in one query. Traditionally you would have to set up, host and manage your own query engine to support federated queries but not when using runQL. We make this easy. Simply add multiple data connections inside one workspace, and in your query window select federated as the data connection. Start typing your query and click run. We handle the rest!

  • Query across multiple databases without hosting your own engine
  • Simple setup — just add connections and select federated

Python Support New

Data teams can now work with data in python. Just select python from the dropdown of data sources in a query window and start coding. You can combine SQL, Cypher (Neo4j) and Python in one workflow.

  • Write and execute Python directly inside runQL
  • Mix SQL, Cypher, and Python in workflows

MongoDB Support New

You can now query mongoDB.

  • MongoDB now available as a supported data source

Comments and Discussions for Certified Query Requests New

You can now comment and have a discussion on certified query requests.

  • Built-in commenting to collaborate on certifications

Stored Procedures and Triggers New

Stored procedures and triggers now show up in the navigator.

  • Procedures and triggers easily accessible from the navigator

Private vs Shared Queries New

By default a query you save is private, until you explicitly share it via the share button. This is a change from our old default of everything being shared automatically.

  • Saved queries are private by default now
  • Explicit sharing through the share button

Execute Multi-line Statements New

We now support running multi-line sql statements inside one query window.

  • Run multiple SQL commands in a single query execution

Answer Page Charts New

Business users can now view both data results from approved queries as well as the approved chart.

  • Approved data results and charts shown together for business users

Search Improvements Update

We have made several changes to search and auto suggestions to make it even better!

  • Better matching, faster suggestions across queries

Query Management - Versioning Update

We have made versioned queries and non-saved queries more clear in the UI.

  • Clearer UI separation for saved vs. draft query versions

View and Edit Query Question New

You can now view and edit the query question generated for a saved query.

  • Full control to tweak the natural language question

Run Each Workflow Step Separately New

You can now run each step in a workflow separately.

  • Test and run workflow steps independently

Custom CA Certificate Support New

We now support uploading your own CA certificates for SSL database connections.

  • Custom CA cert upload for secured database connections

Invite, Onboarding and Sign In Update

Multiple updates to make the process for inviting new users to your organization clear and make first time onboarding smooth.

  • Improved clarity and guidance for new users

Query Result Messaging Update

Add messaging to queries with no results.

  • Clear message when queries return no data

API Updates Update

We made changes to the API which will be invisible to you. We've done this in preparation for our desktop application.

  • Prepares runQL for local desktop app connectivity

UI and Bug Fixes Update

Sign in/Sign up pages have been updated.
Highlighting text in the query window has been updated.
Postgres queries failing bug has been fixed.
Info card for query metadata getting cut off has been fixed.
Long query titles cut off in the UI has been fixed.
Move delete saved query to the admin tab.
Fix results when two fields with the same column name are used in federated queries or multi-table joins.
Change to use OpenAI structured JSON.
Bug fix for handling large queries in saved queries and suggestions.
Bug fix for running large queries.

  • Dozens of UX and reliability improvements across runQL

What We're Working On 🚀

  • UI for editing data, structures, indexes, and foreign keys
  • Tracking edits to data/structures — who, when, what
  • Desktop client for local network data access

— The runQL Team