session.exec does not support delete statements

[McEazy2700]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question 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

from sqlmodel import (col, delete)
from common.models import LibrarySoundNFTLink


           
 delete_stmt = delete(LibrarySoundNFTLink).where(
   col(LibrarySoundNFTLink.library_user_address) == address
 )
 session.exec(delete_stmt)

Description

session.exec complains when executing a delete operation with the following error

Pyright: No overloads for "exec" match the provided arguments [reportCallIssue]
Pyright: Argument of type "Delete" cannot be assigned to parameter "statement" of type "SelectOfScalar[_TSelectParam@exec]" in function "exec"
  "Delete" is incompatible with "SelectOfScalar[_TSelectParam@exec]" [reportArgumentType]

I hear I should use session.execute to execute bulk delete operations, but session.execute will soon be deprecated (the warning keeps buging me)

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.14

Python Version

3.12

Additional Context

No response

[jackbravo]

I get the same, this seems like an issue instead of a question :-p

[YoraiLevi]

any directions?

[monchin]

just use execute and ignore the deprecated warning...

[YaoJusheng]

Has the problem been solved? I also encountered the same problem.

I used session.delete instead.

[N-Demir]

Yeah what's going on here?