Detect File Format in clickhouse-local via Filename in Stdin

Why it matters

This feature addresses the issue where clickhouse-local loses the ability to detect the data format if the input is provided through stdin, which can disrupt data processing workflows. By allowing format detection based on the filename alongside stdin, it improves user experience and flexibility in handling input data.

How to use it

When using clickhouse-local, pass the input data through stdin as usual but specify the filename to enable automatic format detection based on the file extension. This requires no additional options; the format detection works transparently based on the provided filename.