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

Queries

• WITH
• SELECT
• FROM
• WHERE
• GROUP BY
• HAVING
• WINDOW
• ORDER BY
• LIMIT & OFFSET
• 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