Norm

Norm is not ORM, it is just a SQL query builder.

Features

• ✓ Select Statement

  • ✓ CTE

  • ✓ SubQueries

  • ✓ Limit …​ Offset

• ✓ Update Statement

• ✓ Delete Statement

• ❏ OO Query Builder

• ❏ Functional Query Builder

• Dialects

  • ❏ SQL Server

    • ❏ 2008

    • ❏ 2008+

  • ❏ MySQL

  • ❏ Oracle

  • ❏ SQLite

  • ❏ PostgreSQL

Dialects

SELECT

LIMIT Clause

Standard

SELECT ...columns FROM table
ORDER BY col1
OFFSET @offset
FETCH FIRST @limit ROWS ONLY

MS SQL 2008

WITH [__RowNumberWrapper_1] AS (
    SELECT ...columns, (ROW_NUMBER() OVER (ORDER BY (col1))) AS [__RowNumber_1]
    FROM table
    ORDER BY col1
)
SELECT ...columns
FROM [__RowNumberWrapper_1]
WHERE [__RowNumber_1] BETWEEN @offset AND (@offset + @limit)

MS SQL 2012+

SELECT ...columns FROM table
ORDER BY col1
OFFSET @offset
FETCH NEXT @limit ROWS ONLY

PostgreSQL

SELECT ...columns FROM table
ORDER BY col1
LIMIT @limit OFFSET @offset