FlySpeed SQL Query is a simple and fast SQL query tool for all database users and developers. It allows you to build queries on many different database servers without needing deep knowledge of SQL syntax and to work with data fast and easy.
FlySpeed SQL Query tool facilitates the process of building SQL by letting you quickly drag and drop tables to create queries, from simple to complex, and combine visual query building with direct SQL text editing.
FlySpeed SQL Query tool combines powerful means of working with SQL queries, high-speed data retrieval and one-click data export and printing to make your work with data more productive than ever before!
Handy for professionals and must-have to newbies, FlySpeed Database Query Tool is free to use without printing and exporting capabilities.
Wide range of supported database servers and desktop databases
* Full support of SQL syntax for Microsoft SQL Server, Oracle, MySQL, Microsoft Jet 4 (MS Access, MS Excel), PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQLite.
* Support of the other ANSI SQL/92, SQL/89 and SQL/2003 compatible database servers such as Teradata, Netezza and desktop databases (Paradox, FoxPro, dBase (DBF)).
* Native connection to Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MS Access, InterBase/Firebird.
* Connection to any other database via ADO or ODBC driver.
o Simple and convenient graphical user interface.
o High-speed data retrieval.
o Full Unicode support.
o Portable installation to work from a USB Flash drive.
o Read-only mode for selected connections.
Simple and convenient database object browser
o Quick access to all data-contained database objects.
o Saving queries to connection's object browser.
o Database objects and queries incremental search and filtration.
Easy SQL query building and fast data browsing
o Easy-to-use visual query builder to build even complex queries.
o Dragging objects and saved queries to the query builder.
o SQL Editor with code completion and syntax highlight.
o Quick data search, sorting and filtration.
o Copying selected records to clipboard.
Advanced features (available in the Standard version only)
o Exporting data to most popular office formats with ease. (Excel, CSV, Text, HTML and XML)
o Printing and exporting data to PDF in a few mouse clicks.
Changelog for this release:
Software copy protection technology was changed for compatibility with Windows 8.
Old registration keys will not be changed, but the tool will have
to obtain the new key for each installation. This will be done
automatically on starting the application. In order to use the software
in Portable mode, please submit a request to obtain a portable
Support of Teradata SQL Syntax is added. Use the new syntax with generic ADO and ODBC connection types.
Now it's possible to sort and filter result data by almost each
grid column (excluding those that were defined via complex SQL
expression without alias).
Double clicking on a datasource column moves focus to the first criteria cell of the newly added criteria item.
An algorithm of choosing datasources for links with complex expressions is improved.
Conditions like "<= :DT_END AND >= :DT_START" are loaded into one cell now.
The "CTE" prefix is added to CTE sub-query tabs to distinguish them from other types of sub-queries.
Select item aliases are used as sub-query tab captions now.
The collapse/expand button is added to each datasource on the visual query builder's diagram pane.
The "Add new Union Sub-Query" (+) button is added to the Union navigation bar.
Now it's possible to highlight even rows of the visual query builder's Query Columns Grid with alternate background color.
The new options are added to take control over the new features.
Command Timeout setting is added to Oracle, Firebird,
InterBase, SQLite and ODBC connection types. It can be found at the
Advanced tab of Connection Properties dialog.
The new data formtting options for the Print View tab allows to
define format of Date and Time data types and to specify fixed decimal
point for numeric data.
The new SQL Dialect option is added for Firebird connection type.
Other minor bug fixes and improvements are made.
Ability to connect to some local or remote database server