sqlContext.sqlDBQuery() throws error when queryCustom contains text literals in single quote

Environment:

Databricks Runtime version: 6.4
Apache Spark version: 2.4.5
Scala version: 2.11
com.microsoft.azure: azure-sqldb-spark:1.0.2

Issue Component: SQLContext.sqlDBQuery()

Issue Summary: even valid sql-query passed to queryCustom if contains string literal enclosed in single quotes, there is an error

Error Messages:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'Alfred Schmidt'
...
at com.microsoft.azure.sqldb.spark.query.QueryFunctions.sqlDBQuery(QueryFunctions.scala:57)

Sample Code to recreate Error:

import com.microsoft.azure.sqldb.spark.config.Config
import com.microsoft.azure.sqldb.spark.query._
val query = """
              |UPDATE Customers
              |SET ContactName = 'Alfred Schmidt', City = 'Frankfurt'
              |WHERE CustomerID = 1;
            """.stripMargin

val config = Config(Map(
  "url"          -> "mysqlserver.database.windows.net",
  "databaseName" -> "MyDatabase",
  "user"         -> "username",
  "password"     -> "*********",
  "connectTimeout" -> "60", //seconds -- 1 min
  "queryTimeout" -> "7200",  //seconds -- 2 hours
  "bulkCopyBatchSize" -> "2500", //rows
  "bulkCopyTableLock" -> "true", //lock table for bulk insert
  "bulkCopyTimeout"   -> "7200" //seconds -- 2 hours

  "queryCustom"  -> query
))

sqlContext.sqlDBQuery(config)

Description:

Even a valid query will throw the above mentioned error if it contains any string literals enclosed in single quotes
If the query is valid, even after throwing the error it gets executed successful. Changes can be seen in the database table.
Thanks to issue: No exception thrown in sqlContext.sqlDBQuery there is no exception and the notebook continues to run

Azure / azure-sqldb-spark

sqlContext.sqlDBQuery() throws error when queryCustom contains text literals in single quote #75