Design flexible and reliable queries within seconds, without writing one single line of SQL. No prior SQL knowledge required. Great tool to learn SQL, with many generated demo queries. Reusable query expressions, conditional formula, generic high-level functions API and fluent/contextual notation.
Get instantly generated vendor-specific SQL, run the read-only SELECT queries directly against relational databases and show the results. Support for almost all popular client-server, cloud and desktop relational databases, including Oracle and SQL Server, PostgreSQL and MySQL, Azure and Amazon Redshift, SQLite and Firebird.
Type less, way less. Auto-quoting identifiers and transparent handling of SQL aliases. Auto-fixing NULL problems. Removes many vendor-specific elements of surprise. Generic string concatenator and operators. Automatic handling of empty but mandatory FROM clauses.
Grouping sets (with CUBE and ROLLUP), pivot/cross tables, Intersect/Except, window functions (with global/contextual ranking and analytic functions), extended aggregates, sort with NULLs and many other advanced features, through either native vendor support or emulated.
Skip-and-Keep queries and transparent built-in paging mechanism. Display format on the end result. Highlight specific cells. Bottom-page summaries calculated on client’s side. Hide or merge duplicate cells together.
Multiple views of an SQL query, with either CTE (Common Table Expressions) or nested SELECT subqueries. Reuse any query as a nested subquery in another new query. Inline subqueries for simple aggregates. Simulate any query for other supported platforms, without having those platforms installed.
Data Xtractor Suite
Combine Query Xtractor with Model Xtractor:
- custom and auto-generated re-engineered data models
- unlimited number of views of your data model
- chain relationships and custom joins, to enhance your model without altering the database itself
- simple, topological or graph models to visualize the inter-connectivity
- structure-focused or relationship-focused data model views