q
q copied to clipboard
Escaping dynamic queries as string literals
For example, the query
SELECT name FROM queries.csv WHERE query = 'DELETE FROM dictionary'
throws the error : file dictionary cannot be found. Is there a way to escape a string literal so that it isn't processed as a query? Thanks.
PS: 'name' and 'query' are column names in the file 'queries.csv'
Hi @hazemkmammu
You're right of course, it's a bug. I'm sorry but I don't have a quick solution for it - It's directly related to #12 , for which I haven't found a proper solution yet.
The number of issues related to #12 was quite low in terms of impact on existing users, so I haven't invested enough time in finding a good enough solution. However, your use case exposes the problem to the fullest, so I'll take a deeper look and see if something can be done.
Thank you very much