Ordering a select drop down from distinct values from query

[Hyperbytes]

@Teodor

Please open a feature request

Already did that some time ago

Ability to apply a SQL function to a field within the query builder

I often find myself needing to apply an SQL function to a field, (using a recent example highlighted by @mrbdrm such as DATE(‘field’) where field is datetime format) as well as items such as Trig functions, other time manipulations and string management. While some of these can be added via repeats or client side formatting it would be useful to be able to apply these directly in the query builder perhaps by a picker like in formatter or dropdown in the “Column” column as in the aggregate col…

Formatters, cast and convert would be nice

(only been 7 years)