Is your feature request related to a problem or challenge?

According to the ANSI SQL specification, floating point numbers in SQL should be interpreted as decimals. We currently interpret them as floats:

    pub struct SqlParserOptions {
        /// When set to true, SQL parser will parse float as decimal type
        pub parse_float_as_decimal: bool, default = false

Describe the solution you'd like

Set default to true and fix regressions in test suite. This will likely involve fixing some bugs in type coercion such as #14272

Describe alternatives you've considered

No response

Additional context

No response