I want to have a query builder where i can paste or modify a select as text an modify it with an grafical intetface.
Drag-and-drop table/view addition
Automatic join detection from FK relationships
Manual join creation and editing
All kind of join support
Table alias generation
Manual alias customization
Column selection via checkboxes
Select-all columns
Column reordering
Column aliasing
Calculated column expressions
SQL expression support
WHERE clause visual builder
AND/OR condition grouping
Nested condition support
IN clause generation
BETWEEN clause generation
LIKE predicate generation
EXISTS predicate support
NULL condition support
Bind variable support
GROUP BY visual configuration
Aggregate function support
COUNT aggregation
SUM aggregation
AVG aggregation
MIN aggregation
MAX aggregation
ORDER BY visual configuration
Ascending/descending sorting
Multi-column sorting
SQL auto-generation
Bidirectional SQL ↔ visual synchronization
SQL parsing into visual diagrams
SQL formatting integration
Automatic indentation and styling
Metadata inspection
Cross-schema query support
Synonym resolution support
View support
Materialized view support
Subquery support
Inline view support
Query execution directly from builder dispaying in existing Data Viewer
Generated SQL live updates
Query validation assistance
Duplicate alias prevention
Query reverse engineering
Metadata-driven autocomplete
Column datatype visualization
Visual-to-text query translation engine
Text-to-visual query reconstruction engine
I want to have a query builder where i can paste or modify a select as text an modify it with an grafical intetface.
Drag-and-drop table/view addition
Automatic join detection from FK relationships
Manual join creation and editing
All kind of join support
Table alias generation
Manual alias customization
Column selection via checkboxes
Select-all columns
Column reordering
Column aliasing
Calculated column expressions
SQL expression support
WHERE clause visual builder
AND/OR condition grouping
Nested condition support
IN clause generation
BETWEEN clause generation
LIKE predicate generation
EXISTS predicate support
NULL condition support
Bind variable support
GROUP BY visual configuration
Aggregate function support
COUNT aggregation
SUM aggregation
AVG aggregation
MIN aggregation
MAX aggregation
ORDER BY visual configuration
Ascending/descending sorting
Multi-column sorting
SQL auto-generation
Bidirectional SQL ↔ visual synchronization
SQL parsing into visual diagrams
SQL formatting integration
Automatic indentation and styling
Metadata inspection
Cross-schema query support
Synonym resolution support
View support
Materialized view support
Subquery support
Inline view support
Query execution directly from builder dispaying in existing Data Viewer
Generated SQL live updates
Query validation assistance
Duplicate alias prevention
Query reverse engineering
Metadata-driven autocomplete
Column datatype visualization
Visual-to-text query translation engine
Text-to-visual query reconstruction engine