FlySpeed SQL Query

Release History

November 19, 2024

FlySpeed SQL Query 4.10.4.1 changelog

  • SnowFlake DB: Freezing on parsing some queries is eliminated.

November 11, 2024

FlySpeed SQL Query 4.10.4.0 changelog

  • Detail views toolbar has been redesigned.
  • IBM DB2: Hanging on parsing queries with the "VALUES" clause is fixed.
  • SnowFlake: Support for colon operator, brackets notation and better parsing of FLATTEN clause is made.

October 21, 2024

FlySpeed SQL Query 4.10.3.1 changelog

  • PostgreSQL: The bug with connecting to a database containing space in its name is fixed.
  • The crash in the data frame with tinyint columns is eliminated.

October 17, 2024

FlySpeed SQL Query 4.10.3.0 changelog

  • MS SQL Server: Queries with PIVOT and UNPIVOT clauses are parsed fine now.
  • A new command to duplicate a record is added. Use the Ctrl+L shortcut or the toolbar button in the Data Grid tab.
  • Now you can quickly turn copying the columns header row to the Clipboard on and off using the toolbar button in the Data Grid tab.
  • Drag and drop and milti-select is possible now in the Grid column selection and ordering window.
  • The bug with not showing toolbar buttons for MDI windows is fixed.
  • The bug with inability to edit data in the Form View is fixed.

October 10, 2024

FlySpeed SQL Query 4.10.2.0 changelog

  • Polish and French localiztions are updated.
  • Data Import Form is speeded up.
  • The data export error reporting is fixed.
  • Now it is possible to export data from selected objects in the tree via the context menu action.
  • MySQL: A possible bug with updating all records in a table on editing a record is fixed.
  • MySQL: Now it is possible to update only fields from the main table in a query. Fields from other tables are made read-only. The main table in a query is a table The which primary key fields are found first.
  • Offline maintenance prolongation is possible now.
  • The error of entering an invalid date when displaying the calendar pop-up is fixed.
  • The "Pending and direct clearance are mutual exclusive!" error is suppressed.

September 12, 2024

FlySpeed SQL Query 4.10.1.0 changelog

  • The initial value for date parameters is now set to the current date/time.
  • Several crashes are eliminated.

August 25, 2024

FlySpeed SQL Query 4.10.0.0 changelog

  • Oracle, PostgreSQL, MySQL and Snowflake: Support for natural and lateral joins is added.
  • Oracle: Support for cross and outer apply is added.
  • PostgreSQL: Support for Only, Materialized and not Materialized CTE hints is added.
  • The regression with switching between cells in Edit mode using the Tab key is addressed.

July 25, 2024

FlySpeed SQL Query 4.9.1.0 changelog

  • Oracle: Queries with PIVOT and UNPIVOT clauses are parsed fine now.
  • The bug with executing of queries which we failed to parse is fixed.

July 16, 2024

FlySpeed SQL Query 4.9.0.1 changelog

  • The occasional crash on closing the tool or a query window is fixed.

July 12, 2024

FlySpeed SQL Query 4.9.0.0 changelog

  • MS SQL Server: Support for CROSS APPLY and OUTER APPLY is made.
  • Visual Query Builder: Editing the whole link expression for complex joins.
  • Visual Query Builder: Switching the join type in the Link Properties dialog and via the link context menu.
  • Visual Query Builder: Cross joins are now drawn on the design pane.
  • Visual Query Builder: Support for numeric order in queries with an asterisk item is improved.
  • Visual Query Builder: An error is thrown now if it's not possible to switch the outer join side for SQLite.
  • SQL Text Editor: List of keywords for PostgreSQL is fixed.
  • Export Tasks: The bug with abandoning filename for a task item on editing it is fixed.