opt: add rule to simplify const comparison with ANY values

[DrewKimball]

Given a constant value compared using the ANY or SOME operators, we should be able to check for constants in the right hand side that can be used to simplify the comparison to True. For example, the expression: 0.1 < ANY (c0, 0.4) could be simplified since 0.1 < 0.4.

Jira issue: CRDB-42979

[zenc0derr]

Hi @DrewKimball, I would like to work on this issue. Can you assign it to me?

[DrewKimball]

Hi @zenc0derr, thanks for picking this one up! Feel free to ask general questions about contributing on our community slack. You can ask questions to do with this issue specifically here.

[DrewKimball]

Hi @zenc0derr, do you think you'll be able to work on this soon? If not, we can unassign you, and give other contributors a chance to work on it.

[zenc0derr]

Hi @DrewKimball, Apologies for the delay. Was not well for few weeks. Working on it now. Thanks

[zenc0derr]

@DrewKimball, could you provide some guidance on where to start with this issue?

[ahuangg]

Hi @DrewKimball, I'm interested in tackling this issue. Would it be possible for you to assign me?