Implement Relaxed Conversion Logic for Codecs

[jchrys]

Existing codec implementation exhibits strict type conversions. For instance, boolean codec converts to boolean only when data type is binary or TINYINT(1) BIT(1). However, In many real-world applications, data stored in MySQL databases can be represented in multiple formats. Specifically, Boolean values might be stored in columns with different data types such as VARCHAR or CHAR, where values like 'true', 'false', '1', '0' are used to represent Boolean states. The current implementation does not support converting these string representations to Boolean values, causing inconvenience and additional data transformation efforts.

[jchrys]

ref: type conversions https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html