Missing some explicit CASTs that are permitted in SQL99

[alancai98]

Current implementation is missing some casts from SQL99 (see section 6.22 ).

E.g. string -> date

PartiQL Shell
Version: 1.0.0-97741fa2f

partiql ▶ CAST('2025-01-30' AS DATE);

e: [runtime] Undefined cast from STRING to DATE.

string -> time

partiql ▶ CAST('11:39:00' AS TIME);

e: [runtime] Undefined cast from STRING to TIME(0).

string -> timestamp

partiql ▶ CAST('2025-01-30 11:39:00' AS TIMESTAMP);

e: [runtime] Undefined cast from STRING to TIMESTAMP(6).