Manage Complex SQL Visually With The Query BuilderMany business professionals are new to SQL. QuerySmith helps you understand joins, data filtering and subqueries, leaving you to focus on the big picture of the problem you’re trying to solve.
Automatically Refresh Workbooks With Charts & Pivot TablesExport to Excel is the most popular feature in most business intelligence products. QuerySmith is fundamentally built around the concept of getting data into your Excel spreadsheets automatically.
Excel’s Missing SQL Query Builder
QuerySmith adds a powerful SQL query builder with support for Oracle, MySQL, Microsoft SQL Server and Postgres. Whether you are new to SQL or experienced, QuerySmith makes it easy to manage complex joins, filter criteria and subqueries, all while generating the proper SQL for your database.
Instant SQL Refresh With The Push Of A Button
You’re almost certainly going to wind up in Excel making financial/operational models, projections and what-if scenarios.
QuerySmith automates the work of getting data out of your database application and into a usable form for further analysis.