"global in" support?

[david-hfx]

I am very happy to see the support of "global join". Does it support "global in" now? How does it work?

[xzkostyan]

GLOBAL IN is not supported yet.

[david-hfx]

Thanks for the reply. I want to know if this feature is planned and when it will be available. Because I feel that this function is quite common.

[xzkostyan]

Currently there is no ETA for this feature. But it's not so hard to implement it. See how it's customized in sqlalchemy.dialects.mssql.base.MSSQLStrictCompiler.visit_in_op_binary.

I'd do the follwing steps for adding it's support:

• add own global_in method in clickhouse_sqlalchemy.orm.query.Query;
• visit it in compiler;
• add support for non-Query places: search by def in_ in SA sources and do the same for global_in.

[david-hfx]

Thanks! This is quite useful for me.

[Simon-Chenzw]

just use column.op("GLOBAL IN", return_type=sa.Boolean)(subquery) this works well for me

docs: https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.Operators.op https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.custom_op