Column Raw Sort Mode seems to be broken
My use case (that is super common) is that I have a column corresponding to days to an SLA. I set the Mapped value of the column, of course to format the SLA as {{ ${-item} d ago }}
The feature tool tip refers to this page, and confirms this is a bug. Getting started with the Table component | Retool Docs
From the documentation
Mode Description Default Sorts based on the mapped value. If the mapped value is unset, the raw value is used. Raw Sorts based on the raw value, regardless of the mapped value. Options Sorts based on a list of options you create manually. Disabled Disables column sort modes.
From my understanding Table > Column > Interaction > Sort mode > Default should sort by the mapped value of the column (by the default of that type; strings lexicograpgically etc) And that Sort mode > Raw would sort by the actual column source value taken from the source, ie {{ item }} before being transformed by the mapped value property.
However this behaviour does not work at all, the sort order appears to be exactly the same as Sort mode > Default
For a reproducible example
Use any numerical column with mixed positive and negative numbers, set the mapped value to {{ ${-item} d ago }}, then set Sort mode > Raw