Sqlite: Multiple IN operators caused an sqlglot.errors.ParseError.

[VLDB2026]

read="sqlite"
dialect="sqlite"
Confirmed on main: reproduces on commit fd6d4d6

Fully reproducible code snippet

import sqlglot
sql = "SELECT 1 NOT IN (0) IN (1)"

ast = sqlglot.parse_one(sql, read = "sqlite")

it output:

sqlglot.errors.ParseError: Invalid expression / Unexpected token. Line 1, Col: 22.
  SELECT 1 NOT IN (0) IN (1)

This query can be successfully executed on sqlite3