If you use proper apostrophes instead of ASCII apostrophe / single quote, you don’t have to escape anything and you get better typography. "don’t" is easier to read than both.
I think that’s only MySQL. Postgres uses double quotes for identifiers and single quotes for literals.
EDIT: I misinterpreted that single quote as a backtick. In any case, both single and double quotes are common in SQL, but single quotes are a bit more common.
If you’re on a Mac, Option-Shift-] will type it.