Reviewer, 2009-06-24 07:53:00

Professional database developers often find it difficult when it comes to building complex SQL queries. Nevertheless, an easier way of getting rid of the entire related hassles is available for database developers in the guise of FlySpeed SQL Query 2.6. The program facilitates building SQL queries easily using visual query builder, thus assisting novice and expert users to build complicated SQL queries in trouble-free graphical manner. The utility functions compatibly with different types of databases and carries out querying task over various database servers and several platforms with no SQL skills required. With the support to print results and export the data, it becomes easier for the users to view and analyze results. The program supports entire SQL dialects of MS SQL Server, MySQL, Oracle, PostgreSQL, Firebird, InterBase, and Microsoft Access databases.

FlySpeed SQL Query creates various SQL queries in proper syntax for almost every supported database in a complete visual manner. The GUI of utility is extremely simple, working on which you first require establishing connection with SQL server using the provided wizard. Filling up the required fields for connecting to the SQL server, such as server selection, username, password, default database, alias, etc, the program connects to the SQL server. You can anytime connect to the server or edit connection properties. Now launch the query window, and add objects like tables, views, procedures, and synonyms; add derived tables, create new or copy union Sub-Query, alter properties, and build and edit query with ease. You can easily create, edit and save the SQL query, and also can add several connections. To support you in building queries, the program also features refresh metadata, SQL text mode, options to view query tree and database objects tree, incremental search, indent/unindent, comment/uncomment lines, connection list, themes, and different settings relating program, formatting, and report.

FlySpeed SQL Query 2.6 software allows carrying out SQL query building task efficiently, thus easing the work of database developers. The program imparts fantastic feature-set added with remarkable performance in SQL query-building, which makes it worthy of 4 rating points.