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

Model relations are automatically loaded regardless of the ModelView configuration, this causes issues with relationships defined as lazy="dynamic" because it ends up in InvalidRequestError( '%s' does not support object population - eager loading cannot be applied.) from sqlalchemy. The error is raised on any list or detail request.

The current workaround I'm applying is:

class ModelView(ModelView):
    def __init__(self) -> None:
        super().__init__()
        self._relations = [rel for rel in self._relations if rel.lazy != "dynamic"]

Steps to reproduce the bug

Setting up two SQLAlchemy Models and configuring a relationship between them with the lazy="dynamic" parameter should suffice

Expected behavior

1. Relationships not being listed as part of column_list or column_details_list are not eagerly loaded
2. Relationships with lazy="dynamic" are either ignored (short term fix?) or correctly handled (longer term feature?)

Actual behavior

InvalidRequestError causes the ModelView to be unusable for models with lazy="dynamic" relationships

Debugging material

Starlette Debugger.pdf

Environment

• OS: Debian 11 (Bullseye)
• Python: 3.11
• SQLAlchemy: 1.4.44

Additional context

No response