FlySpeed SQL Query

Release History

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.

July 04, 2024

FlySpeed SQL Query 4.8.7.1 changelog

  • PostgreSQL: Crashes and slow load of queries is fixed.
  • PostgreSQL: Export of GUID data is fixed.
  • Parameter values form: The default value for dates is set to today.

June 24, 2024

FlySpeed SQL Query 4.8.7.0 changelog

  • Visual Query Builder: If a join consists of more than one conjunction, the whole expression is available for editing in the Link Properties dialog.
  • New ciphers and hashes are available now for SSH tunnel connections.
  • Calculation of the Changed state for a query is fixed to avoid confusion and unnecessary prompt.
  • More correct use of system colours in some custom Windows themes.
  • Now it is possible to select the SnowFlaks SQL syntax for generic OLE DB connection.
  • Data Grid: Columns and the bottom totals line parameters are saved correctly now.
  • Data Grid: The crash on adding a new detail frame is fixed.
  • PostgreSQL: The list of keywords is fixed.

May 06, 2024

FlySpeed SQL Query 4.8.6.0 changelog

  • Detail data views creation is optimized.
  • Lots of mior data view bugs are fixed.
  • Pervasive: Fields ordering is fixed.
  • DBISAM: Using comma in the Extract function instead of FROM is allowed for ANSI SQL generic SQL dialects.

April 05, 2024

FlySpeed SQL Query 4.8.5.0 changelog

  • The object fields loading is optimized.
  • Creation of data export tasks for queries in sub-folders is fixed.
  • Idle CPU load is minimized.
  • Firebird: Connection to embedded servers is fixed.
  • Firebird: The ability to create a new database is added.
  • The bug with displaying the number of selected rows for detail data views is fixed.
  • Unhandled crashes while working with data view are eliminated.

March 12, 2024

FlySpeed SQL Query 4.8.4.1 changelog

  • The bug with executing a query with unnamed parameters is fixed.
  • The bug with data view filtration and sorting is fixed.
  • The crash on undoing changes with focused visual query builder is eliminated.

March 07, 2024

FlySpeed SQL Query 4.8.4.0 changelog

  • French localization is updated
  • Pervasive: metadata loading is fixed.
  • Parameter values form initialization is optimized.
  • Data view: the number of selected rows now displayed in the status bar.
  • Azure: MFA authentication for AAD is enabled.

January 26, 2024

FlySpeed SQL Query 4.8.3.0 changelog

  • MySQL: New aggregate functions are added.
  • Snowflake: The bug with some aggregate function names is fixed.
  • Snowflake: Support for POSITION and FLATTEN functions is made.
  • MS SQL Server: Support for WITHIN expression is made.
  • SQL text editor: New SQL Server functions are added to the suggestions list.
  • SQL text editor: Suggestions list tooltips are back.
  • Informix: The fault on opening a query during the metadata load has been addressed.
  • Informix: The "Inexact character conversion during translation" error is handled.
  • Oracle: The fault on retrieving data using the 64-bit ODBC driver has been eliminated.

December 30, 2023

FlySpeed SQL Query 4.8.2.0 changelog

  • Data Export to .xslx is speeded up up to 4x.
  • Data Export via OLE DB is optimized in memory use.
  • Data Grid view toolbar customizations are saved between sessions now.
  • MySQL: Parsing of "=false" and "=true" expressions is speeded up.

December 21, 2023

FlySpeed SQL Query 4.8.1.0 changelog

  • Data grid: Per-column data format and appearance customization is made.
  • Data grid: Saving of column order between sessions is fixed.
  • Export tasks: Option to overwrite existing files or abort is added.
  • Firebird: Appliance of the client library property is fixed.
  • Oracle: Parsing of expressions with parentheses is optimized.