Generate SQL
Review Generated SQL
Check fields, joins, filters, calculations, and output shape before running generated SQL.
Steps
1
Confirm selected columns
Check aliases and source fields against the requested result.
2
Review joins
Verify relationship paths, join columns, and join types.
3
Review filters and calculations
Check dates, status values, null handling, aggregates, and grouping.
4
Test in the target database
Use representative data and normal query-review controls.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.