FlySpeed SQL Query

Release History

October 01, 2021

FlySpeed SQL Query 3.9.1.0 changelog

  • Visual Query Builder: You can filter fields in datasources on the Design Pane, and hide unused fields in a single click.

September 23, 2021

FlySpeed SQL Query 3.9.0.3 changelog

  • 7-day trials are added.
  • DB Explorer: Query creation and modification dates are shown in the hint.
  • Denodo: Double primary keys fields loading is eliminated.

September 10, 2021

FlySpeed SQL Query 3.9.0.2 changelog

  • The bug with scrolling the SQL text to the left is fixed.
  • An exception on trying to execute a query with empty SQL text editor is eliminated.
  • Minor improvements were made.

September 08, 2021

FlySpeed SQL Query 3.9.0.1 changelog

  • Now it's possible to switch between statements in the script, edit each SELECT statement in the Visual Query Builder, and execute statements one by one on the SQL Text tab.

August 02, 2021

FlySpeed SQL Query 3.8.5.0 changelog

  • The ability to select visible databases for connection is back. Metadata filter obeys this selection so it takes less time to load metadata.
  • The ability to select visible schema for Oracle and other servers that support multiple schemas but don't support databases is added.
  • Filter on the Result Data tab wasn't applied to Data Export if aliases were used in the query. Fixed now.
  • The subscription update process has been made easier.
  • It is possible now to select a single statement in the script on the SQL text tab with Ctrl + [Left button click].
  • Denodo Virtual DataPort metadata loading fixes are made.

July 01, 2021

FlySpeed SQL Query 3.8.4.3 changelog

  • The recently introduced bug with exporting data has been fixed.
  • Fixes for the Metadata Filter Editor are made.
  • The bug with copying table data from the grid to the clipboard using the Ctrl+C shortcut is fixed.
  • Animation on executing the sub-query data preview query is added.
  • Other minor fixes are made.

June 25, 2021

FlySpeed SQL Query 3.8.4.1 changelog

  • PostgreSQL: Database objects weren't displayed for new connections, fixed now.
  • SQL Text Editor: The bug with not selecting the whole word on double-click is fixed.
  • Denodo Virtual DataPort: Metadata loading has been fixed.
  • Metadata Filter Editor doesn't hang anymore.
  • Unnecessary prompts on copying large chunks of data to clipboard aren't displayed now.
  • Form View: A button to display more fields is added to the bottom.
  • Objects are added unsorted to the DB Explorer tree.
  • The windows toolbar is draggable again.
  • The bug with not remembering the expanded state of connection folders is finally fixed now.
  • Several unexpected errors are eliminated.

June 09, 2021

FlySpeed SQL Query 3.8.3.0 changelog

  • The Oracle connection properties form has been redesigned. Now you can switch between different ORACLE_HOME settings and pick the right TNS name from the list. The ability to specify port and service name in separate controls has been made.
  • The New Connection Wizard has been redesigned. Now you can switch between OLE DB, ODBC, and direct connection to the database server. The database selection step has been simplified.
  • The expanded/collapsed state of connection folders is now saved between work sessions.
  • The way the date and time added to the export file name has been improved.
  • The initial support for Denodo Virtual DataPort has been added.
  • Teradata: A fallback to non-X system views if X-views are not available has been made.
  • Metadata filter bugs are fixed.

May 13, 2021

FlySpeed SQL Query 3.8.2.0 changelog

  • The ability to export and import queries saved in connections has been made. It is now a complete set of settings to make backups and move settings to another PC. Use the Options - Export/Import Settings menu for this.
  • The new database object filter made it easier. You can open the dialog to define filters on the Settings tab of the Connection Properties dialog.
  • Data Export: MRU list for the filename is added.
  • Data Export: A new option allows for adding the current date and time to the filename automatically.
  • It is now possible to filter the lookup data in the filter builder on the Data View tab.
  • One can execute the selected fragment from the query text in a new window. The appropriate toolbar button changes its caption when text is selected in the editor.
  • Visual Query Builder: Now it's possible to save the layout of the Visual Query Builder tab layout, including panes visibility and ratio, the width of columns in the Query Columns Grid. Use the "Save the default visual query builder layout" toolbar button on the Query Builder tab.
  • One can close windows by right-clicking on the windows bar buttons.
  • Data View: Captions of detail data tabs are made shorter.
  • The new global option to display "null" text for NULL values is added to the Grid View tab.
  • It's now possible to hide the Preview tab below the Visual Query Builder via the "Show data preview on the Query Builder tab" global option on the Query Window tab.
  • MySQL and other servers where applicable: The new option to use checkboxes for displaying and editing fields of TINYINT type is added to the Advanced tab of the Connection Properties dialog.
  • DB2: Support for the EXCEPTION JOIN is added.
  • DB2 for AS/400: Connection to old versions is hopefully fixed.
  • Pervasive: Parsing of the IF, DateAdd, DateDiff, and DatePart functions, and the DOUBLE built-in type is fixed.

March 05, 2021

FlySpeed SQL Query 3.8.1.1 changelog

  • Support for HiRes scaling modes has been improved.
  • DB Explorer: Inline renaming of connections is possible now with the F2 shortcut.
  • DB Explorer: The position of query/connection drop is indicated more precisely now.
  • Query window: Now it's possible to switch between tabs using the Ctrl+1-5 shortcuts.
  • Other minor bugfixes and UI improvements are made.