sqlc.yaml

version: "2"
sql:
  - engine: "postgresql"
    queries: "db/queries"
    schema: "db/migrations/postgres"
    gen:
      go:
        package: "dbsqlc"
        out: "internal/dbsqlc"
        # Phase-3 §3.1: switched from pgx/v5 to database/sql so the
        # generated Queries surface plugs into the existing *sql.DB
        # pool on postgres.Store without a parallel pgxpool. We keep
        # pgx as the underlying driver (registered via pgx/v5/stdlib);
        # this change only affects the *types* sqlc emits for rows
        # and parameters.
        sql_package: "database/sql"
        emit_pointers_for_null_types: true
        overrides:
          # The only nullable JSONB column in the schema. Mapping it to
          # json.RawMessage matches every other JSONB column in the
          # codebase (audit_events.details, jobs.payload, etc.) and avoids
          # pulling in github.com/sqlc-dev/pqtype just for one column:
          # database/sql scans SQL NULL into a nil json.RawMessage
          # natively and accepts a nil json.RawMessage as a NULL parameter.
          - column: "enrollment_events.fields_json"
            go_type:
              import: "encoding/json"
              type: "RawMessage"
              pointer: true
            nullable: true