Fix: Invalid AsDate values now return null fix

Fix: date fields suffixed with AsDate return null if the date is invalid, instead of throwing an error. The situation can arrive when an invalid date was set in the system (a feature used in some limited scenarios). The actual date can still be fetched using the column field of type Int.

New orderBy sorting argument

New argument orderBy for defining the sorting order of the results. See Sorting.

Warning

The previous sortOrder argument is deprecated and will be removed in the future.

New distinct query argument

Support for fetch distinct values using a new query argument called distinct. See Distinct values.

Warning

The previous schema section for aggregates, which includes distinct, is obsolete and will be removed in the future. See Aggregates.

Faster pagination with hasNextPage

Performance improvement for pagination when hasNextPage is requested. For tables of tens of millions of records, the execution time is reduced with 20-25 seconds.