Checklist

• The bug is reproducible against the latest release or master.
• There are no similar issues or pull requests to fix it yet.

Describe the bug

sqladmin/models

def _run_query_sync(self, stmt: ClauseElement) -> Any:
    with self.session_maker(expire_on_commit=False) as session:
        result = session.execute(stmt)
        return result.scalars().unique().all()

In the code, the use of a with ... as ... statement to manage the session led to an unexpected closure of the session, which may caused the following error in some case:

sqlalchemy.orm.exc.DetachedInstanceError:

https://docs.sqlalchemy.org/en/20/errors.html#parent-instance-x-is-not-bound-to-a-session-lazy-load-deferred-load-refresh-etc-operation-cannot-proceed

This error occurs because closing the session detaches instances that still require the session for lazy loading or other operations.

To resolve this, I modified the code to manage the session explicitly, avoiding its premature closure. This change prevents the DetachedInstanceError by keeping the session open until all required operations are complete.

def _run_query_sync(self, stmt: ClauseElement) -> Any:
    session = self.session_maker(expire_on_commit=False)
    result = session.execute(stmt)
    return result.scalars().unique().all()

With this modification, the error no longer occurs, and the instances remain attached to the session as needed.

Steps to reproduce the bug

No response

Expected behavior

No response

Actual behavior

No response

Debugging material

No response

Environment

Windows 10 / ptyhon 3.10.11 / sqladmin 0.16.1

Additional context

No response