EMS logo

Products Navigation

SQL Query for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for InterBase/FireBird

Product News

SQL Query version 3.3 released

We are pleased to announce the new minor version of SQL Query - the powerful utility that lets you quickly and simply build SQL queries to SQL Server, MySQL, PostgreSQL, InterBase/Firebird, Oracle, and DB2 databases.

You can download SQL Query version 3.3 from the following links:

SQL Query for MySQL:

SQL Query for PostgreSQL:

SQL Query for SQL Server:

SQL Query for InterBase/Firebird:

SQL Query for Oracle:

SQL Query for DB2:

What's new in SQL Query 3.3?

  1. Added the possibility to parse subqueries in the JOIN statement. 
  2. Query Builder:
    • Added the automatic display of the JOIN statement for tables with foreign keys (DB2, InterBase/Firebird, MySQL, Oracle).
    • Added the possibility to use aggregate functions in the CASE statement.
  3. Added the possibility to execute only the selected part of a query in Query Editor.
  4. When parsing a query, which contained the name of a table starting with an underscore, AV error occurred. Fixed now.
  5. In SQL Query for DB2 it was not possible to execute a query after error occurrence. Fixed now.
  6. SQL Query for PostgreSQL:
    • It was not possible to execute query when using a cast operator. Fixed now.
    • When setting a button bar, the button headers were missing. Fixed now.
  7. SQL Query for MySQL. When parsing the UPDATE query with a subquery in the WHERE clause, an error occurred. Fixed now.
  8. SQL Query for InterBase/Firebird:
    • Executing queries with subqueries in the field list caused an error. Fixed now.
    • Now all data is sorted correctly.
  9. The program parameters were saved incorrectly. Fixed now.
  10. Some other improvements and bugfixes.

We hope you’ll enjoy working with our products.