[ENH] Add separate scalar handling for cast

[ayushdg]

Is your feature request related to a problem? Please describe. Based on discussions in #495 , it might make sense to handle scalar operations such as casting more cleanly.

Describe the solution you'd like Explore a path for handling scalars in a more general manner while casting (as well as other rex call operations if applicable).

Describe alternatives you've considered

Additional context