Can I make emacs recognize double-quoted strings in sql-mode?

Question

I am looking for a way to make sql-mode highlight double-quoted strings in the same way as single-quoted strings. Setting the product to MySQL (which is the correct product for me) did not achieve this result.

Answer 1

Maybe this?

(let* ((mysql (alist-get 'mysql sql-product-alist))
       (syntax (plist-get mysql :syntax-alist)))
  (plist-put mysql :syntax-alist (cons '(?\" . "\"") syntax)))