Should the `generic` dialect support numeric literals with underscore separators?

Right now, the `generic` dialect (DataFusion's default) does not support numeric literals with separators:

```sql
DataFusion CLI v54.0.0
> select 1_000;
+------+
| _000 |
+------+
| 1    |
+------+
```

I'm wondering if the  `generic` dialect should support this, just like Postgres/DuckDB/SQLite/Clickhouse, so DataFusion can use them directly without needing to switch to another dialect.