DanCodedThis

Support `...::BINARY` & `CAST(... AS BINARY)` via a `to_binary` UDF call

Support `...::CHAR` & `CAST(... AS CHAR)` via a `to_char` UDF call

Support `...::BOOLEAN` & `CAST(... AS BOOLEAN)` via a `to_boolean` UDF call

Support `...::NUMBER(precision, scale)` & `CAST(... AS NUMBER(precision, scale))` via a `to_time` UDF call

Support `...::TIME` & `CAST(... AS TIME)` via a `to_time` UDF call

Support date input format for `to_date` UDF and cast via (or): - Akin to `to_timestamp` impl - Creating an Arc map for context vars - Some other way (DF `SessionContext`...

engine: Aliases bug

3

## Error While working on `to_date` and `try_to_date` UDFs (PR: #1376; Issues: #624 & #1156). I got this error multiple times (similar ones), both in SLT tests and insta tests:...

- In #1362 we introduced a patch (fix) for #1361 (Number (Decimal128) was made a Float64 in DF losing digits). - The fix makes any DF Float type as Decimal...

- Any statements only work with lowercased Identifiers for tables (probably, schemas, databases, fields, etc) - This doesn't work: ```sql CREATE OR REPLACE TABLE mytable_1 (amount NUMBER); SELECT table_name FROM...

Add support for binary string format and formatting (such as: `SELECT TO_DECIMAL('ae5', 'XXX')` -> `2789`) Basic `to_decimal`: #1339 Reference: https://docs.snowflake.com/en/sql-reference/functions/to_decimal#examples