Allow to declare number fields in schema.json so that comparison and sort by default use number order, not string order.
Add the /number modifier to enable number matching, comparing and sorting, for example age ==/number 18, age >=/number 21 and sortBy age/number.
The workaround requires additional front-end effort:
This additional effort is not justified and should be avoided.
A field "foo" may contain a String in one record and a number in some other record:
CQL2PgJson doesn't know the data content when building the query.
This can only be fixed if a field is explicitly declared as number in schema.json.
Current implementation that requires the workaround:
Add a "number" array to the table entry in schema.json similar to the "index" array: