Skip to content

engine future side effect when False #526

Description

@priamai

First Check

  • I added a very descriptive title to this issue.
  • I used the GitHub search to find a similar issue and didn't find it.
  • I searched the SQLModel documentation, with the integrated search.
  • I already searched in Google "How to X in SQLModel" and didn't find any information.
  • I already read and followed all the tutorial in the docs and didn't find an answer.
  • I already checked if it is not related to SQLModel but to Pydantic.
  • I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

  • I commit to help with one of those options 👆

Example Code

engine = create_engine(settings.DATABASE_URI, echo=True, connect_args=connect_args,future=False)

data_df = pd.read_sql(table_name, con=engine, parse_dates=['datetime'])

Description

I am using FASTAPI and SQLModel with Pandas.
I create dataframes and convert them to json before returning them.
I need to set the future = False otherwise pandas is unable to read sql.
Will this have any side effects on the framework?

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.8.10

Additional Context

No response

Activity

  1. faizanazim11 commented on Jan 25, 2024

    @faizanazim11

    Can you share the library versions that you are using?

    i.e:

    • Pandas
    • SQLAlchemy
    • Psycopg or any other DBAPI
  2. locked and limited conversation to collaborators on Aug 7, 2025
  3. converted this issue into a discussion #1460 on Aug 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions