validate_sql_object
Validate SQL blocks against BSG standards to get a compliance score (0-100) and a list of violations with severity and fix suggestions.
Instructions
Performs full structural validation of a SQL block (CREATE TABLE, VIEW, SP, FUNCTION, TRIGGER) against BSG standards. Returns a compliance score (0-100) and a list of violations with severity and suggestions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The full SQL block to validate | |
| schema | No | Expected schema (e.g., 'com', 'mkt') — optional. If provided, verifies the object uses this schema. | |
| object_type | Yes | Type of SQL object being validated |