**Use case**

```
clickhouse-local --query "SELECT * FROM file(0, JSONEachRow)" < something
```

**Additional context**

I also tried other intuitive options:
```
clickhouse-local --query "SELECT * FROM file(stdin, JSONEachRow)" < something
clickhouse-local --query "SELECT * FROM file('-', JSONEachRow)" < something
```

Although this works:
```
clickhouse-local --query "SELECT * FROM file('/dev/stdin', JSONEachRow)"
```

I think, solution with numeric file descriptors should be supported, as we already support it for `File` table engine,
and it is also useful if a script is opening file descriptors with higher numbers like

```
clickhouse-local --query "SELECT * FROM file(5, JSONEachRow)" 5<test
```

Note: it is already possible to process stdin in clickhouse-local and it is also intuitive and convenient:

```
clickhouse-local --query "SELECT * table" < something
```

I just want other ways to work consistently.
#pragma once
#include <TableFunctions/ITableFunctionFileLike.h>
namespace DB
{
/* file(path, format[, structure, compression]) - creates a temporary storage from file
 *
 * The file must be in the clickhouse data directory.
 * The relative path begins with the clickhouse data directory.
 */
class TableFunctionFile : public ITableFunctionFileLike
{
public:
    static constexpr auto name = "file";
    std::string getName() const override
    {
        return name;
    }
    ColumnsDescription getActualTableStructure(ContextPtr context) const override;
private:
    StoragePtr getStorage(
        const String & source, const String & format_, const ColumnsDescription & columns, ContextPtr global_context,
        const std::string & table_name, const std::string & compression_method_) const override;
    const char * getStorageTypeName() const override { return "File"; }
};
}