Formatted SQL will appear here…Frequently Asked Questions
What SQL dialects does this formatter support?
Supports MySQL, PostgreSQL, SQLite, Microsoft SQL Server (MSSQL), and Oracle SQL. Auto-detection identifies dialect-specific keywords and also detects bracket notation [name] and OUTER APPLY as MSSQL syntax.
Why does the validator show errors for bracket notation?
Bracket notation like [column] is MSSQL-only syntax. If you're using MySQL or PostgreSQL, switch your dialect to MSSQL or replace brackets with backticks (MySQL) or double quotes (PostgreSQL).
What does "Undefined table/alias reference" mean?
This error appears when a table alias is used in WHERE or JOIN conditions but was never defined in a FROM or JOIN clause. For example, referencing t.column when table t is not in the query.
Can I format multiple SQL queries at once?
Yes. Paste multiple queries separated by semicolons. The tool splits them into numbered tabs for individual formatting and analysis.
What does the Code Snippet feature generate?
Generates ready-to-use code snippets in multiple programming languages with proper formatting and syntax highlighting for easy integration into your projects.