[Umbrella] Improve Beam ZetaSQL type system

[damccorm]

This is an umbrella issue for several improvements we plan to make to the Beam ZetaSQL type system.

Imported from Jira BEAM-10238. Original Jira may contain additional context.
Reported by: robinyqiu.