Apostrophes not inserted

[jdelStrother]

Is it intentional that Riddle::Query::Insert strips apostrophes from its values?

irb> Riddle::Query::Insert.new(:posts, ["title"], ["jon's stuff"]).to_sql
=> "INSERT INTO posts (`title`) VALUES ('jons stuff')"

I'm not sure if Riddle ought to be fixed to escape the apostrophe appropriately, or if I need to strip apostrophes from search queries when trying to find them later with ThinkingSphinx

[pat]

Belated response, but this really does feel like a bug to me. I'll look into having Riddle escape apostrophes instead of stripping them out.

[pat]

Took me longer than I wanted to sort this out, but I've changed the behaviour so they're properly escaped (and thus Sphinx's character settings can decide what the right behaviour is) rather than removed, and this is available in the freshly-published v2.4.0 release.