[Sqlalchemy-tickets] Issue #3549: sqlalchemy.exc.UnsupportedCompilationError JSONB (zzzeek/sqlalchemy)

[flashmob <iss...@bi...>]

New issue 3549: sqlalchemy.exc.UnsupportedCompilationError JSONB
https://bitbucket.org/zzzeek/sqlalchemy/issues/3549/sqlalchemyexcunsupportedcompilationerror

flashmob:

Trying to compile query:


```
#!python

_update = str(S.__table__.update().where(and_(*_filters)).values({col.name: func.jsonb_concat(col,func.cast(bindparam(bind_name), JSONB))}))
```

and getting error:


```
#!python

sqlalchemy.exc.UnsupportedCompilationError: Compiler <sqlalchemy.sql.compiler.GenericTypeCompiler object at 0x108cd6110> can't render element of type <class 'sqlalchemy.dialects.postgresql.json.JSONB'>

```

if I remove cast then sqlalche,y trying to cast dict to HSTORE

Responsible: zzzeek