PostgreSQL¶

Scythe's primary and most complete dialect. All features are supported.

Supported features¶

• Enums -- CREATE TYPE ... AS ENUM (...) parsed and mapped to enum::name
• Composite types -- CREATE TYPE ... AS (...) mapped to composite::name
• Arrays -- TEXT[], INTEGER[], etc. mapped to array<T>
• JSONB / JSON -- mapped to json; typed JSON via @json_typed annotation
• Views -- resolved through underlying table definitions
• Domains -- CREATE DOMAIN resolved to base type with NOT NULL propagation
• Range types -- int4range, tstzrange, etc. mapped to range<T>
• Network types -- INET, CIDR, MACADDR mapped to inet

Type mapping table¶

PostgreSQL-specific annotations¶

-- @name GetUser
-- @returns :one
SELECT id, name, email FROM users WHERE id = $1;

• Parameter placeholders use $N syntax ($1, $2, ...)
• RETURNING clause support for :one and :many on INSERT/UPDATE/DELETE
• ON CONFLICT (UPSERT) is fully supported
• SERIAL / BIGSERIAL columns are automatically marked NOT NULL

Placeholder syntax¶

PostgreSQL uses positional $N placeholders:

INSERT INTO users (name, email) VALUES ($1, $2);