with_statement_hint() has lost its generative capability

[zzzeek]

regression somewhere in 2.0

from sqlalchemy import select


s1 = select(1)
s2 = s1.with_statement_hint("foo")

assert s1 is not s2

[zzzeek]

broke in 3b4d62f

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the main branch:

restore generative to with_statement_hint https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/5461

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the rel_2_0 branch:

restore generative to with_statement_hint https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/5462