Open pstaabp opened 4 years ago
Oops, sorry I missed this! I'll take a look at it tomorrow.
I'm not sure if I want to support this...the SQL syntax is a tuple, which works fine. I think maybe instead, if you try to use a raw vector in QuerySQLite, I could throw an error and suggest using a tuple instead?
I was trying to do a filter for a value in an array. Here's an example using the Chinook db:
which returns the error:
and piping to
get_sql
has [ ] around the array, where SQL needs parens ( ).If we run:
we get the expected results.