MySQL type BIT is not a boolean

[schveiguy]

Currently, the library expects BIT type to really be a boolean. But it's not, it's a bitfield (an array of bits).

MySQL normally treats BOOL or BOOLEAN types as TINYINT, which means that's what we should do for bool.

This probably requires a deprecation period, but this should be done after the @safe update is done.