List the structure of the file() function for various formats

[danthegoodman1]

The docs do not indicate what the column from each format when using https://clickhouse.com/docs/en/sql-reference/table-functions/file

For example using 'LineAsString' returns the line column. Nowhere (that I could reasonably find) is this documented.

The shortcut was to make a crap tiny file and print out the select so I could see what the columns are.

I am also not sure there is a function to read the columns returned by a subquery so that I could use a query to inspect it like:

select columns(select * from file('...', 'LineAsString'))