rules:
  - id: delete-where-no-execute
    patterns:
      - pattern: $X.delete().where(...)
      - pattern-not-inside: $X.delete().where(...).execute()
      - pattern-not-inside: $C.execute(...)
    message:
      .delete().where(...) results in a no-op in SQLAlchemy unless the command is executed, use .filter(...).delete()
      instead.
    languages: [python]
    severity: ERROR
    metadata:
      category: correctness
      technology:
        - sqlalchemy