Set DBAPI paramstyle to match what DBR supports

Jesse Whitehouse · Jesse Whitehouse · commit 08f551aa0f2e · 2023-09-26T16:44:33.000-04:00
Signed-off-by: Jesse Whitehouse &lt;jesse.whitehouse@databricks.com&gt;
diff --git a/src/databricks/sql/__init__.py b/src/databricks/sql/__init__.py
@@ -5,7 +5,7 @@
 # PEP 249 module globals
 apilevel = "2.0"
 threadsafety = 1  # Threads may share the module, but not connections.
-paramstyle = "pyformat"  # Python extended format codes, e.g. ...WHERE name=%(name)s
+paramstyle = "named"  # Python extended format codes, e.g. ...WHERE name=%(name)s
 
 
 class DBAPITypeObject(object):
diff --git a/src/databricks/sqlalchemy/__init__.py b/src/databricks/sqlalchemy/__init__.py
@@ -82,7 +82,7 @@ class DatabricksDialect(default.DefaultDialect):
     supports_native_decimal: bool = True
     supports_sane_rowcount: bool = False
     non_native_boolean_check_constraint: bool = False
-    default_paramstyle: str = "qmark"
+    paramstyle: str = "named"
 
     @classmethod
     def dbapi(cls):
