Skip to content

Support Snowflake JOIN with no join conditions #5795

@kyle-cheung

Description

@kyle-cheung

Is your feature request related to a problem? Please describe.
Snowflake is interesting where they allow specifying JOINs with no join conditions. This is treated as a CROSS join, however this doesn't transpile nicely into DuckDB where

SELECT *
FROM table_a
JOIN table_b

will transpiles into DuckDB as

SELECT *
FROM table_a
JOIN table_b

Which will throw a syntax error

Describe the solution you'd like
Would love if possible to transpile this into a cross join if there are no join conditions

Describe alternatives you've considered
Gotta manually regex this!

Additional context
n/a

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions