Support casting from DataType::Utf8 to DataType::Boolean

[MazterQyou]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Casting strings to bools is more or less trivial and is useful for comparison between values of those two types.

Describe the solution you'd like
It makes sense to implement Utf8 to Boolean cast with respect to PostgreSQL boolean cast, accepting values of true, yes, on, 1, false, no, off, 0 as valid boolish strings, as well as their unique prefixes, ignoring the case and whitespace (again, following PostgreSQL convention).

Describe alternatives you've considered
N/A

Additional context
N/A