Headers with column names containing spaces not supported

[ghost]

input.csv:

Column 1,Column 2
A,B
C,D

Query:

textql -header -sql 'select [Column 1]' input.csv

Expected result:

A
C

Actual result:

2017/05/23 15:21:00 no such column: Column 1

Quoting the column names does not help.

[arendtio]

The same problem seems to exist for column names containing dots, like Column.1

[awildeep]

I got this working if I quote the fields AND leave the FROM clause in the SQL statement.

EG: textql -header -sql 'select [Column 1] from [input]' input.csv

[arendtio]

I can confirm the workaround by @awildeep works for columns with dots too.

[gabrielf]

The workaround also works when working on stdin by selecting from the table named stdin like this:

$ echo "Column 1,Column 2
A,B
C,D" | textql -header -sql 'select [Column 2] from stdin'
B
D

Backticks can also be used instead of square brackets.

[awildeep]

I think this issue could be closed with some documentation surrounding these work-arounds.