use select style api in orm #15508

Open
opened 2026-02-21 19:22:03 -05:00 by yindo · 1 comment
Owner

Originally created by @asukaminato0721 on GitHub (Jul 20, 2025).

Originally assigned to: @asukaminato0721 on GitHub.

Self Checks

  • I have read the Contributing Guide and Language Policy.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing? Tell me about your story.

now the using of db.session.query gives very terrible typing result.

use new select api will make it better.

2. Additional context or comments

https://docs.sqlalchemy.org/en/20/orm/queryguide/select.html

https://docs.sqlalchemy.org/en/20/changelog/migration_20.html#migration-orm-usage

3. Can you help us with this feature?

  • I am interested in contributing to this feature.
Originally created by @asukaminato0721 on GitHub (Jul 20, 2025). Originally assigned to: @asukaminato0721 on GitHub. ### Self Checks - [x] I have read the [Contributing Guide](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) and [Language Policy](https://github.com/langgenius/dify/issues/1542). - [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [x] I confirm that I am using English to submit this report, otherwise it will be closed. - [x] Please do not modify this template :) and fill in all the required fields. ### 1. Is this request related to a challenge you're experiencing? Tell me about your story. now the using of `db.session.query` gives very terrible typing result. use new select api will make it better. ### 2. Additional context or comments https://docs.sqlalchemy.org/en/20/orm/queryguide/select.html https://docs.sqlalchemy.org/en/20/changelog/migration_20.html#migration-orm-usage ### 3. Can you help us with this feature? - [ ] I am interested in contributing to this feature.
yindo added the 💪 enhancementgood first issue labels 2026-02-21 19:22:03 -05:00
Author
Owner

@dosubot[bot] commented on GitHub (Aug 24, 2025):

Hi, @asukaminato0721. I'm Dosu, and I'm helping the Dify team manage their backlog and am marking this issue as stale.

Issue Summary:

  • You proposed updating the codebase to use SQLAlchemy's new select API for better typing support.
  • This change aligns with the SQLAlchemy 2.0 migration guide.
  • You expressed willingness to contribute this improvement.
  • No further discussion or activity has occurred since your initial proposal.

Next Steps:

  • Please let me know if this issue is still relevant to the latest version of Dify by commenting here.
  • Otherwise, this issue will be automatically closed in 15 days.

Thank you for your understanding and contribution!

@dosubot[bot] commented on GitHub (Aug 24, 2025): Hi, @asukaminato0721. I'm [Dosu](https://dosu.dev), and I'm helping the Dify team manage their backlog and am marking this issue as stale. **Issue Summary:** - You proposed updating the codebase to use SQLAlchemy's new select API for better typing support. - This change aligns with the SQLAlchemy 2.0 migration guide. - You expressed willingness to contribute this improvement. - No further discussion or activity has occurred since your initial proposal. **Next Steps:** - Please let me know if this issue is still relevant to the latest version of Dify by commenting here. - Otherwise, this issue will be automatically closed in 15 days. Thank you for your understanding and contribution!
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#15508