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
• Numbers
• Operators
• Arrays and Maps
• Comments

Queries

• WITH
• SELECT
• FROM
• WHERE
• GROUP BY
• HAVING
• WINDOW
• ORDER BY
• LIMIT & OFFSET
• Non‐standard clauses
• Set operations

DML statements

• INSERT INTO
• UPDATE
• DELETE FROM
• TRUNCATE TABLE (non-standard)
• MERGE INTO (non-standard)

DDL statements:

• CREATE TABLE
• CREATE VIEW
• ALTER TABLE
• DROP TABLE

About formatting SQL

• SQL formatting standards and tools