SQL Column Name Extractor

How to use this developer tool

1. Paste the sql select statement or load a local text file.
2. Adjust the available checks or parsing options.
3. Select Extract Columns or press Ctrl/Cmd + Enter.
4. Review the summary, detailed output, and structured export before using the result.

What this developer tool does

Break a SELECT list into expressions, source references, and output aliases. Commas inside functions and parentheses are preserved, quoted aliases are recognized, and qualified column references are collected for a compact view of what the query returns.

Star expansion depends on the database schema, so * and table.* remain wildcards rather than guessed column lists.

Example

The bundled sample demonstrates the expected input. Select Sample, run the analyzer, and compare the detailed output with the summary metrics.

SELECT o.id AS order_id, c.name, SUM(o.total) AS revenue
FROM orders o JOIN customers c ON c.id = o.customer_id
GROUP BY o.id, c.name;

Use cases

• Pre-commit and code-review checks
• Query or repository troubleshooting
• Generating copy-ready diagnostics for an issue

Tips for reliable output

• Use the exact text that the target system will receive.
• Keep dialect- or policy-specific options aligned with your project.
• Review warnings even when the main result is valid.
• Save structured JSON when another script needs the findings.
• Confirm destructive operations in the real environment separately.

Processing details

Finds the top-level SELECT…FROM range, splits only on top-level commas, and analyzes aliases and identifier references within each item.

Star expansion depends on the database schema, so * and table.* remain wildcards rather than guessed column lists.