Troubleshooting
SQL References the Wrong Column
Correct generated SQL when a business term was mapped to an unintended schema field.
Steps
1
Identify the intended field
Confirm the exact table and column in Review Schema.
2
Refine the prompt
Name the exact field or use Find schema fields while writing prompts.
3
Ask for the correction
Tell the assistant which reference should be replaced and preserve unrelated logic.
4
Review all occurrences
Check SELECT, JOIN, WHERE, GROUP BY, HAVING, and ORDER BY references.