Search results

BUG: Sql select from database type cast issue

Bug

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#62013 In pandas-dev/pandas;

· Closius opened on Jul 31, 2025

Writing data to mysql database using df.to_sql method gives exception

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Status: Open.

#61711 In pandas-dev/pandas;

· MohammadHilal1 opened on Jun 26, 2025

BUG: pd.read_sql is incorrectly reading long int when connecting to Teradata

Bug

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#61667 In pandas-dev/pandas;

· IzidoroBaltazar opened on Jun 16, 2025

BUG: Type error supplying SQLAlchemy NVARCHAR length in to_sql()

Bug

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Typingtype annotations, mypy/pyright type checking type annotations, mypy/pyright type checking

Status: Open.

#61660 In pandas-dev/pandas;

· philipnye opened on Jun 14, 2025

Parallelize test_sql.py - Issue #60378

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Stale

Testingpandas testing functions or related to the test suite pandas testing functions or related to the test suite

Status: Open (in progress).

pandas-dev/pandasnumber 61551

#61551 In pandas-dev/pandas;

· dShcherbakov1 opened on Jun 4, 2025

BUG/FEATURE REQUEST: DataFrame.to_sql() tries to create table when it exists

Bug

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs DiscussionRequires discussion from core team before further action Requires discussion from core team before further action

Needs InfoClarification about behavior needed to assess issue Clarification about behavior needed to assess issue

Status: Open.

#61418 In pandas-dev/pandas;

· vladidobro opened on May 9, 2025

BUG: to_sql works only for strings

Bug

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs InfoClarification about behavior needed to assess issue Clarification about behavior needed to assess issue

Status: Open.

#61385 In pandas-dev/pandas;

· pdojs opened on May 1, 2025

ENH: Adding hint to to_sql

Enhancement

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#61370 In pandas-dev/pandas;

· AliKayhanAtay opened on Apr 28, 2025

ENH: Functionality to aid with Database Imports

Closing CandidateMay be closeable, needs more eyeballs May be closeable, needs more eyeballs

Enhancement

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#61247 In pandas-dev/pandas;

· mwiles217 opened on Apr 7, 2025

BUG: The <code>.to_sql()</code> of <code>dtype</code> argument does not strictly ensure the column name and datatype

Bug

Closing CandidateMay be closeable, needs more eyeballs May be closeable, needs more eyeballs

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Status: Open.

#60737 In pandas-dev/pandas;

· ammarsaf opened on Jan 20, 2025

ENH: pd.to_sql(upsert=True, upsert_on_columns=['game_id'])

Enhancement

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#60434 In pandas-dev/pandas;

· vile319 opened on Nov 27, 2024

ENH: Add table prefixes to to_sql method

Enhancement

IO SQLto_sql, read_sql, read_sql_query to_sql, read_sql, read_sql_query

Needs TriageIssue that has not been reviewed by a pandas team member Issue that has not been reviewed by a pandas team member

Status: Open.

#60422 In pandas-dev/pandas;

· Diadochokinetic opened on Nov 26, 2024