Query Pilot Syntax Checking

Help ID: query-runner.syntax

The check button validates the active tab. Live syntax checking uses the same validation path while typing.

The checker uses the configured batch separator and validates each batch independently. It warns when statements that must start a batch are mixed with earlier statements.

When Auto-insert batch separators is enabled in Query Pilot options, the editor inserts the configured batch separator immediately above batch-start-only statements as they are typed. The manual check button also applies the same fix to pasted or existing SQL before it validates the script.

The shared batch separator fixer applies to statements such as CREATE PROCEDURE, ALTER PROCEDURE, CREATE FUNCTION, ALTER FUNCTION, CREATE VIEW, ALTER VIEW, CREATE TRIGGER, and ALTER TRIGGER. It skips insertion when the nearest previous meaningful line is already the configured batch separator.

Errors appear as editor squiggles and in the Messages tab. Missing variable declarations are warning-level feedback.

Related: Query Pilot, Options.

Documentation revision: 33D20A28BA481AD0