Parse a string into a boolean value using consistent rules across the codebase
Accepts: true/false, t/f, yes/no, y/n, 1/0 (case-insensitive except for numbers)
Parse a string value into the appropriate DataValue type
Order of precedence: Null -> Boolean (text only) -> Integer -> Float -> DateTime -> String
Note: “1” and “0” are parsed as integers, not booleans, for data consistency