SQL Helper

An advanced tool for analyzing and generating SQL queries for Vertica databases via SQL Workbench/J (JDBC)

Analyzing your query

Generating your SQL query

SQL Query Builder
1
Select Tables
2
Choose Columns
3
Define Query
4
Result
Select Tables

Choose one or more tables to include in your query.

Select multiple tables to join data. Tables are automatically added when selected.
No tables selected yet
Choose Columns

Select the columns you want to include in your query.

Column selection will appear here

Define Your Query

Describe what you want to do with the selected tables and columns.

Your Selection Summary
Be as specific as possible about filters, sorting, and calculations you need.

Building your SQL query