python connection: SQL column renaming doesn't work

[leahwangibm]

Hi,

I noticed that the SQL renaming clause AS doesn't work if there are no operations on those columns, AS renaming wouldn't work.
e.g.

SELECT TRIM(COL_A) AS NEW_COL_A, 
               COL_B AS NEW_COL_B

we will end up with a dataframe has header as NEW_COL_A and COL_B. Has anyone else encountered the same issue before?

query="""<SQL query>"""
df = pd.read_sql(query, db_conn) # db_conn is the database instance I set up via jaydebeapi

Thanks in advance!

[gordthompson]

I was able to reproduce the issue. This patch appears to fix it.

Index: jaydebeapi/__init__.py
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
diff --git a/jaydebeapi/__init__.py b/jaydebeapi/__init__.py
--- a/jaydebeapi/__init__.py	(revision 53b2d6a571aac5ea192b0b9d03f38ecc3f94e71d)
+++ b/jaydebeapi/__init__.py	(date 1732632090413)
@@ -488,7 +488,7 @@
                     dbapi_type = None
                 else:
                     dbapi_type = DBAPITypeObject._map_jdbc_type_to_dbapi(jdbc_type)
-                col_desc = ( m.getColumnName(col),
+                col_desc = ( m.getColumnLabel(col),
                              dbapi_type,
                              size,
                              size,