SQL Table Reference Extractor

Review practical table references locally with explicit heuristic limits for dynamic SQL and vendor-specific grammar.

Extract likely SQL table references

Find common references following FROM, JOIN, UPDATE, INTO, CREATE TABLE, and ALTER TABLE positions. CTE names are shown separately so they are not mistaken for physical tables.

WITH active_users AS (SELECT id FROM app.users WHERE active=true)
SELECT a.id,o.total
FROM active_users a
JOIN sales.orders o ON o.user_id=a.id;
UPDATE audit.log SET checked=true WHERE id=1;

—Table refs

—CTEs

—Statements

—Warnings

Name	Role	Classification

This extractor is intentionally heuristic. It does not resolve dynamic SQL, views, synonyms, search paths, schemas, table-valued functions, or every vendor grammar.

Before running the SQL

The SQL layer keeps transformation, generation, and inspection in the browser. Existing /SQL engines remain intact while the new inspector adds statement, table/CTE, placeholder, clause, and bounded structural-warning context.

Parser and execution boundary

WebToolArc does not connect to a database or execute these statements. The shared scanner handles common lexical structures, quoted strings/identifiers, comments, parameters, and practical references, but it is not a vendor-complete grammar, schema validator, optimizer, lineage engine, or security review. Use a real database/parser when those guarantees matter.