Function listSubjects

packages/core/sdk/src/executor.ts:6875–6894

(
        options?: AdminListSubjectsOptions,
      )

      };

      const listSubjects = (
        options?: AdminListSubjectsOptions,
      ): Effect.Effect<readonly AdminSubject[], StorageFailure> => {
        // Always both, always integers — see `normalizeAdminPaging`. Passing
        // them through independently produced a bare OFFSET, which SQLite
        // rejects outright.
        const { limit, offset } = normalizeAdminPaging(options);
        return platformCore
          .findMany("subject", {
            // Oldest first, ties broken on the unique key so the order is
            // total and paging can't repeat or skip a row.
            orderBy: [
              ["created_at", "asc"],
              ["external_id", "asc"],
            ],
            limit,
            offset,
          })
          .pipe(Effect.map((rows) => rows.map(rowToAdminSubject)));
      };

      // Keyed on `(tenant, external_id)` — the table's unique index. No
      // `tenant` clause here: the tenant policy adds it to every read, the