Clickhouse-local (and its shorthand alias, ch) now use an implicit FROM table when there is input data for processing

Why it matters

This feature addresses the inconvenience of explicitly specifying a FROM table clause in clickhouse-local queries when input data is piped or provided. By automatically adding the implicit FROM clause, it streamlines local data processing workflows. Format inference further simplifies usage by automatically detecting the input data format if not explicitly provided, reducing manual configuration.

How to use it

When using clickhouse-local or its alias ch, simply provide input data without needing to add FROM table in your queries. If no --input-format is specified and a regular input file is processed, the format will be automatically inferred and applied.