SQL Formatter for Subqueries
Your data never leaves your browserDeeply nested subqueries need indentation to show hierarchy.
Example
SELECT name FROM users WHERE id IN (SELECT user_id FROM orders WHERE total > (SELECT AVG(total) FROM orders)) ORDER BY name;
Tips
- 1Each level indents more.
- 2Consider CTEs instead.
- 3Format innermost first.
Frequently Asked Questions
CTEs better?
Usually more readable.
Max depth?
10+ but refactor if >3-4.
Performance?
Formatting doesn't affect it.