cast($expression as float) should work

I've just stumbled again about mariadbs inability to cast stuff to float. Decimal is supported, but float is not (while it is available as a type).

To me that is an inconsistency that should be avoided - therefore casting to float should be allowed.