Text to SQL — plain English to a validated schema

-- Prompt:
-- "Track support tickets. Each ticket belongs to a customer,
--  has a priority, a status, and many comments over time."

CREATE TABLE support.tickets (
  ticket_id     BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  customer_id   BIGINT      NOT NULL REFERENCES support.customers (id),
  priority      TEXT        NOT NULL
                            CHECK (priority IN ('low','medium','high','urgent')),
  status        TEXT        NOT NULL DEFAULT 'open'
                            CHECK (status IN ('open','pending','closed')),
  opened_at     TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE TABLE support.ticket_comments (
  comment_id    BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  ticket_id     BIGINT      NOT NULL REFERENCES support.tickets (ticket_id),
  body          TEXT        NOT NULL,
  created_at    TIMESTAMPTZ NOT NULL DEFAULT now()
);