Cannot parse `select 1 in ()`

I'm not sure if this should parse, Postgres for example also fails, but if possible it would be nice if this at least parsed if not executed correctly.

I tested this in datafusion-cli, but originally found it using Rust:

```
> SELECT 1 in (); 🤔 Invalid statement: sql parser error: Expected: an expression:, found: )
```

Start by reproducing `SELECT 1 in ();` in datafusion-cli and inspect the SQL parser entry point that reports the expected-expression error. Confirm the intended treatment of an empty IN list, then add coverage for the chosen parsing behavior; done means the parser test and CLI behavior agree with that decision.

Written by the indexing model from the issue text.