My sqlite database has columns which consist of TEXT objects containing spaces. I'm new to both emacs and programming, and while I want to use emacsql for reasons, it's crucial that I can select on string objects containing spaces.
(emacsql db [:select * :from table1 :where (= name "John Q Doe-Deer")])
doesn't work, and neither does
'John\ Q\ Doe-Deer: they both returned
nil even though an analogous query works in command-line sqlite. What am I missing?