[✨ FEATURE] ORM Support for SQL Data Nodes

[JPluess]

🔍 Feature Description

ORM (Object–Relational Mapper):
A tool that maps database tables to Python classes, allowing developers to interact with data as Python objects instead of writing raw SQL. Supports CRUD operations, relationships, and type-safe queries, simplifying database integration in applications.

💡 Proposed Solution

Add ORM support for SQL table data nodes, allowing developers to map tables to Python classes and perform CRUD operations using Python objects.

📈 Impact of the Feature

Simplifies database integration, reduces boilerplate SQL, and makes Taipy pipelines easier to use in larger Python applications, benefiting both new and experienced users.

📜 Code of Conduct

• I have checked the existing issues to avoid duplicates.
• I am willing to work on this issue (optional)

✅ Acceptance Criteria

• A working demo or example code (if applicable) is provided.
• Integration tests demonstrate the new functionality.
• Any new code is covered by unit tests.
• Code coverage remains at least 90%.
• Related documentation updates and release notes are created.

[Naveencodespeaks]

Hi @JPluess 👋

I’d like to work on implementing ORM support for SQL Data Nodes.
This feature will help simplify database integration, reduce repetitive SQL boilerplate, and make Taipy pipelines more intuitive for developers working with complex relational data.

My plan is to:

Implement an ORM layer leveraging SQLAlchemy for mapping SQL tables to Python classes.

Extend the existing SQLTableDataNode to support model-based CRUD operations.

Ensure seamless integration with existing Data Node configuration workflows.

Add unit tests, integration tests, and example notebooks to demonstrate end-to-end usage.

Please assign me this issue so I can proceed with development. 🙌

Thanks,
Naveen (Naveencodespeaks)

[Naveencodespeaks]

🚀 PR Ready for Review

Hi @JPluess @alexTaipy,
I've implemented ORM support for SQL Data Nodes using SQLAlchemy.

✅ Added ORMSessionManager & SQLAlchemyTableDataNode with full CRUD support.
✅ All unit tests passed successfully (pytest ... 3 passed, 0 failed).
📌 PR Link: #2746

Looking forward to your review and feedback. 🙂

[JPluess]

Hey Naveen, i am very thankful for your commit, i wish for the taipy maintainer to review.