Impossible to query collections with hyphen in name

[jonas-maertens-c24]

Hi,

I noticed SQL queries (in Superset) with a hyphen in the collection name fail as I could not find a way to escape the hyphen.

SELECT * FROM collection-name LIMIT 100

returns

Error parsing near '-' at line 1:19

The same happens when wrapping the collection name in "`". When wrapping in double quotes ("), no data is returned.

A workaround is of course to create a view without the hyphen in the name for every affected collection, but it would be nice to have a way to use these collections directly.

[passren]

@jonas-maertens-c24 Yeah, Hyphen in table name isn't supported by PartiQL grammar. I added it into grammar as well as parser of pymongosql but still get blocked by superset parser. It seems like superset prevents special characters from table name.
I did find the issue when handle double quotes wrapping the collection name and the issue get fixed. You can update to v0.4.3 and use double quotes on collection name if hyphen exists.

[jonas-maertens-c24]

Thanks for the quick response and fix! With v0.4.3 it's working.