[Sqlalchemy-tickets] Issue #4198: Expanding bindparam does not support Enums (zzzeek/sqlalchemy)

[Robert D. <iss...@bi...>]

New issue 4198: Expanding bindparam does not support Enums
https://bitbucket.org/zzzeek/sqlalchemy/issues/4198/expanding-bindparam-does-not-support-enums

Robert Ditthardt:

I'm assuming there are just missing features here because experimental. That said...

Attached is a test file that demonstrates the observed behavior.

I think that it should be unnecessary to need to get the "name" attribute of an enumeration for "in_" queries that require bound parameters that are enumerations. It should be sufficient to just pass in the enumeration as it is when the Table is properly configured.

I should also note that the mysql driver has slightly different behavior. It doesn't throw an exception, but instead just silently generates a bad query, where each enum in the raw sql ends up as "TestEnum.FOO" instead of "FOO".