Simpler parametrization of query collections

const accountIdsCollection = createCollection(
  queryCollectionOptions({
    syncMode: "on-demand",
    queryKey: ["account", "id"],
    queryFn: () => fetch("/api/my/accounts").then((r) => r.json()),
    getKey: (data) => data.externalId,
    queryClient,
  })
);

const accountsDataCollection = createCollection(
  queryCollectionOptions({
    syncMode: "on-demand",
    queryKey: ["account", "data"],
    queryFn: ({ meta }) => {
      const ids = parseLoadSubsetOptions(meta?.loadSubsetOptions).filters.find(
        ({ operator, field }) =>
          operator === "in" && field.length === 1 && field[0] === "externalId"
      )?.value;

      if (!ids) throw new Error("No ids found");

      const params = new URLSearchParams({ ids: ids.join(",") });

      return fetch(`https://external.abc/api/?${params}`).then((r) => r.json());
    },
    getKey: (data) => data.accountId,
    queryClient,
  })
);

createCollection(
  liveQueryCollectionOptions({
    query: (q) =>
      q
        .from({ account: accountIdsCollection })
        .join(
          { data: accountsDataCollection },
          ({ account, data }) => eq(account.externalId, data.accountId),
          "left"
        ),
    startSync: true,
  })
);