ElegantInsights
AI settingsSQL Comments

SQL Comments

Include /* */ explanatory comments.

Last updated on

Default: On · Type: On / off

When enabled, generated SQL includes inline /* … */ comments explaining what each part of the query does, useful for learning or for sharing queries with colleagues. Disable for cleaner, comment-free SQL.

What changes

On adds inline explanatory comments on key lines (8 to 11); the query is otherwise identical.

On

sql
SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaInt        /* the ticket's customer */JOIN TStatus ts ON ts.TStatus = f.Status  /* status description */WHERE f.FDeleted = 0      /* exclude deleted tickets */    AND f.Status <> 9     /* exclude closed tickets */    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Off

sql
SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    ts.TStatusDesc AS [Status],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Where to change it

Set this under Profile → Prompt settings in the app. See all AI settings.

SQL Column Detail

Controls column selection in SQL queries.

Table Aliases

Use short aliases (f.) vs full names.

On this page

Where to change it