Make `cast_booleans` also cast BIT(1)

Using `BIT(1)` to represent booleans is a common pattern within MySQL. This makes the existing `cast_booleans` switch cast `BIT(1)` as TrueClass or FalseClass