q icon indicating copy to clipboard operation
q copied to clipboard

Escaping dynamic queries as string literals

Open hazemkmammu opened this issue 9 years ago • 2 comments

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'

hazemkmammu avatar Nov 28 '16 10:11 hazemkmammu

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.

harelba avatar Nov 28 '16 11:11 harelba

Thank you very much

hazemkmammu avatar Nov 28 '16 11:11 hazemkmammu