Home

This wiki is used for documenting differences between various SQL dialects.

Useful material for developers of SQL Formatter. Not that useful if you just want to use SQL Formatter.

SQL syntax

Reference of SQL syntax variations.

• Identifiers
• Parameters
• Variables
• Strings
• Arrays and Maps

Queries

• WITH
• SELECT
• FROM
• WHERE
• GROUP BY
• HAVING
• WINDOW
• ORDER BY
• LIMIT & OFFSET

Statements

• INSERT INTO
• UPDATE
• DELETE FROM
• CREATE TABLE
• CREATE VIEW
• ALTER TABLE

About formatting SQL

• SQL formatting standards and tools