version: "2"
sql:
  - engine: postgresql
    schema: migrations
    queries: queries
    gen:
      go:
        package: db
        out: internal/db
        sql_package: pgx/v5
        emit_json_tags: true
        emit_pointers_for_null_types: true
        overrides:
          - db_type: uuid
            go_type: string
          - db_type: jsonb
            go_type:
              import: encoding/json
              type: RawMessage
          - db_type: timestamptz
            go_type:
              import: time
              type: Time
