FlySpeed SQL Query
Release History
- 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.
- 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.