Open
Description
Grammar or Syntax Description
- The PREWHERE clause in ClickHouse is not currently supported by the parser.
- Example: PREWHERE clause is used for filtering rows before the SELECT list is processed.
SQL Example
```
SELECT * FROM table PREWHERE column_name = 'value'
```
exception=Encountered unexpected token: "prewhere" <S_IDENTIFIER>
at line 30, column 9.
Was expecting one of:
","
";"
"APPLY"
"CONNECT"
"CROSS"
"EXCEPT"
"FOR"
"FULL"
"GROUP"
"HAVING"
"INNER"
"INTERSECT"
"JOIN"
"LEFT"
"MINUS"
"NATURAL"
"ORDER"
"OUTER"
"PIVOT"
"RIGHT"
"START"
"STRAIGHT_JOIN"
"UNION"
"WHERE"
"WINDOW"
<EOF>
Additional context
JSQLParser Version: [4.7.0]
ClickHouse Version: [23.x]
Reference documentation: [https://clickhouse.com/docs/en/sql-reference/statements/select/prewhere]