Move unary diagnostic logic from sql planner to analyzer

[Jefffrey]

This checking is normally done as part of analysis (not the sql planner) (aka in an Analyzer rule) -- if we put it in sql planning then it won't apply to queries that don't come from SQL.

Originally posted by @alamb in #21288 (comment)