support cast inside values

[kmitchener]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
(This section helps Arrow developers understand the context and why for this feature, in addition to the what)

Describe the solution you'd like
A clear and concise description of what you want to happen.

Like in PG, would like to be able to cast to target datatype from within the values() statement

❯ select arrow_typeof(a) from (values(34::tinyint), ('2'::tinyint)) as t(a);
+------------------+
| arrowtypeof(t.a) |
+------------------+
| Int8             |
| Int8             |
+------------------+
2 rows in set. Query took 0.004 seconds.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.