How to select a column name containing spaces?

[infojunkie]

In the attached xlsx sheet, the header contains a column with spaces. How can I select this column? Writing dsq space.xlsx "SELECT \"Header with Space\" as header" yields:

[{"header":"Header with Space"}]

which is not what I meant.

[eatonphil]

Which version of dsq are you running? There was a spaces related bug fix in 0.20.2

[infojunkie]

Runing 0.20.2 here. I brielfy looked at the commits, and it seems you are quoting the sqlite fields - but here I'm talking about the cli invocation. I also failed to access the field from within the repl.

[eatonphil]

What shell are you using? It works for me on both mac:

And linux:

[infojunkie]

Oh, I was writing "SELECT \"Header with Space\" as header" without from {}. Sorry!

[eatonphil]

aha yeah I missed that in your initial message. Great!