Skip to content

Conversation

@mitsuhiko
Copy link
Contributor

This implements "FROM-first" selects. DuckDB and Clickhouse support this syntax where FROM can be placed before SELECT. To disambiguate these cases for formatting I added a new SelectFlavor enum:

  • SelectFlavor::Standard: SELECT *
  • SelectFlavor::FromFirst: FROM ... SELECT *
  • SelectFlavor::FromFirstNoSelect: FROM ... (implied SELECT)

I'm not sure if this is the right approach.

Refs #1400

Copy link
Contributor

@iffyio iffyio left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM! Thanks @mitsuhiko!
cc @alamb

@iffyio iffyio merged commit 46cfcfe into apache:main Feb 9, 2025
9 checks passed
@mitsuhiko mitsuhiko deleted the feature/from-first branch February 9, 2025 18:46
ayman-sigma pushed a commit to sigmacomputing/sqlparser-rs that referenced this pull request Apr 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants