[Feature]: Sorting and $in where filter

[starknetdev]

Feature Request

To perform any paginated queries the data requires sorting. Currently any query will give results in a random order, and querying with a limit will always rerun until all data is fetched.

Secondly, cross referencing entities to fetch is difficult without $in filters. Currently I need to perform a single fetch for my paginated results, which is not optimal.

Proposed Solution

Enable the following queries:

Sorting

  sdk.getEntities({
    query: useMemo<TournamentGetQuery>(
      () => ({
        tournament: {
          TournamentModel: []
        },
      }),
      []
    ),
    callback: (resp) => {
      if (resp.error) {
        console.error("useSdkGetEntities() error:", resp.error.message);
        return;
      }
      if (resp.data) {
        setEntities(resp.data);
      }
    }
    orderBy: {
      tournament_id: "asc",
    },
    limit: 10,
    offset: 0
  });

In where filter

  sdk.getEntities({
    query: useMemo<TournamentGetQuery>(
      () => ({
        tournament: {
          TournamentEntriesModel: {
            $: {
              where: {
                tournament_id: { $in: tournamentIds },
              },
            },
          },
        },
      }),
      [tournamentIds]
    ),
    callback: (resp) => {
      if (resp.error) {
        console.error("useSdkGetEntities() error:", resp.error.message);
        return;
      }
      if (resp.data) {
        setEntities(resp.data);
      }
    }
  });

This is also useful in subscriptions.

Alternatives

No response

Related Code

No response

Additional context

No response

If the feature is accepted, would you be willing to contribute it?

• Yes I would be willing to contribute