HogQL: Support for JOIN ... USING ...

[thmsobrmlr]

Is your feature request related to a problem?

We currently don't support JOIN ... USING ... in HogQL. Usually queries can be rewritten to JOIN ... ON .... However this is only possible if a common supertype for the types on the left and right side exists. See the ClickHouse manual for an example, where this isn't possible: https://clickhouse.com/docs/en/sql-reference/statements/select/join#implicit-type-conversion.

Describe the solution you'd like

We support JOIN ... USING ....

Describe alternatives you've considered

Usually queries can be rewritten to JOIN ... ON ....

Additional context

• A test case is implemented here, however no working solution yet: feat(hogql): add support for using join contraint #20269