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 column.
Would this be possible.
Pushing my luck further, can queries be made accessible in server connect (preferably with parameters)