4 November 2025

New SQL transformation UI

Share this message

The SQL editing interface is redesigned to provide a better experience for SQL developers. The new user interface now offers a state-of-the-art SQL editor which includes:

  • More screen real-estate to write SQL queries, including the ability to write multiple queries and run them separately using query selection.

  • The dataset list includes both current and history variants for each datasets, along with a select statement generator.

  • Several keyboard shortcuts have been added for increased efficiency; for example, run query, comment lines, search and replace.

  • Ability to see the last executed query and the time it took to complete.

  • Automatic parameter assignment to datasets.

SQL transformation editor

In addition to the above, the SQL editing experience still offers syntax highlighting, auto-completion, auto-parameterization, auto-formatting, undo/redo, and the SQL Assistant.

Adding SQL transformations

How can we help?

Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have.