Support smaller decimal types through SQL interface

Part of https://github.com/apache/datafusion/issues/17489.

Due to a [bug](https://github.com/apache/arrow-rs/issues/8362) in `arrow-rs`, the new smaller decimal values couldn't have been used through the SQL interface. Now that arrow 56.2.0 is released (and soon to be [updated here](https://github.com/apache/datafusion/pull/17631)), support in `datafusion-sql` should be implemented + slt tests to verify the behavior of various aggregations which are supported now after #17501.