`CAST( 'yes' AS BOOLEAN)` fails about duckdb HOT 3 OPEN

Python casts "yes" and "no" both to True. The RDBMS you mention cast one to True and one to False, I assume. Best to not pick a side, IMO. I prefer there being no cast at all and requiring the user to write down themselves (using case statements) how to convert strings to Booleans. For example, you might be interested in yes/no parsing, the next person might be interested in True/False parsing, the next person in Y/N, the next person in non-empty vs empty string, the next person in string vs null, the next person in Ja/Nein.

from duckdb.

SQLite casts to false (0)

from duckdb.

SQLite casts to false (0)

I can't argue about that because it really depends what DuckDB is aiming for. My recommendation was to aim for H2 or HyperSQL at least and most time you refer to Postgres yourself. (SQLLite and MySQL are less appealing to me.)

We can close this issue immediately. I just write down things I notice while going through all DuckDB functions systematically. Your call please.

from duckdb.