Handle comparaison of dates in the "WHERE" clause

[vserret]

If we do:
SELECT * FROM retail_transactions t WHERE t.transaction_timestamp > '2023-01-01'

the WHERE condition is not considered because '2023-01-01' is seen as a string.

And if we do:
SELECT * FROM retail_transactions t WHERE t.transaction_timestamp > CAST('2023-01-01' AS date)
This does not work because value is not implemented for cast_as_date