XtractPro Launches Query Xtractor, a Visual Query Builder and SQL Generator

NORTH VANCOUVER, British Columbia - Sept. 8, 2016 - PRLog -- Query Xtractor is a visual SQL query builder, generator and runner. With great graphics and visual effects, Query Xtractor helps you build within seconds complex SELECT queries, without even knowing SQL.

Generic vendor-independent interface and universal support for over a dozen database platforms, including Oracle and Microsoft SQL Server, MySQL and PostgreSQL, SQLite and Firebird, cloud databases such as Amazon Redshift and Microsoft SQL Azure Database.

Major Features in Query Xtractor version 1.0 include:

• Emulation of missing features, such as pivot/cross tables and grouping sets.
• Emulation of intersect/except, extended aggregate functions, ALL/ANY etc, when not implemented.
• Extended sort with NULLs first or last in any database.
• Learn SQL from generated demo queries or queries you design from scratch.
• Type less and let us auto-quote identifiers and handle internal SQL aliases.
• Automatic fix of known SQL gotchas, NULL or math problems, vendor-specific inconsistencies.
• Switch from nested subqueries to CTEs, for multiple SQL query views.
• Use complex window functions.
• Auto-detected lookup fields and powerful drill-down on relationships.
• Visual effects, with graphic bar columns, same icons for duplicates, unique value detection etc.

For more details on the new software release, please see our presentation screens (https://data-xtractor.com/query-xtractor/) and the product information (https://data-xtractor.com/product/query-xtractor/).