Implement explicit `CAST` operator

[hatyo]

Currently it is not possible to explicitly cast literals and expressions to other types. This makes it difficult or even impossible to present certain literals that align well with the underlying type system for example, currently, it is not possible to project an empty array literal [] because it is not possible to flow unknown types which is fair, but there is no way to cast it to a known type neither:

select [] from t;