version: "2"
sql:
  - engine: "postgresql"
    queries: "./internal/infrastructure/persistence/postgres/sqlc/queries"
    schema: "./internal/infrastructure/persistence/postgres/sqlc/schema"
    gen:
      go:
        package: "database"
        out: "./internal/infrastructure/persistence/postgres/sqlc/generated"
        sql_package: "pgx/v5"
        emit_interface: true
        emit_json_tags: true
        emit_db_tags: true
        emit_prepared_queries: false
        emit_exact_table_names: true
        emit_empty_slices: true
        emit_enum_valid_method: true
        emit_all_enum_values: true
        # DDD specific configurations
        emit_pointers_for_null_types: true
        emit_result_struct_pointers: true