• Auto-generated type-safe SQL Builder
  • Types - boolean, integers(smallint, integer, bigint), floats(real, numeric, decimal, double precision),
    strings(text, character, character varying), date, time(z), timestamp(z) and enums.
  • Statements:
    • SELECT (DISTINCT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, FOR, UNION, INTERSECT, EXCEPT, sub-queries)
    • INSERT (VALUES, query, RETURNING),
    • UPDATE (SET, WHERE, RETURNING),
    • DELETE (WHERE, RETURNING),
    • LOCK (IN, NOWAIT)
• Auto-generated Data Model types - Go types mapped to database type (table or enum), used to store
  result of database queries. Can be combined to create desired query result destination.
• Query execution with result mapping to arbitrary destination structure.