> ## Documentation Index
> Fetch the complete documentation index at: https://docs.codeant.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Correctness

<AccordionGroup>
  <Accordion title="bad-operator-in-filter">
    Only comparison operators should be used inside SQLAlchemy filter expressions. Use `==` instead of `is`, `!=` instead of `is not`, `sqlalchemy.and_` instead of `and`, `sqlalchemy.or_` instead of `or`, `sqlalchemy.not_` instead of `not`, and `sqlalchemy.in_` instead of `in_`.
  </Accordion>

  <Accordion title="delete-where-no-execute">
    .delete().where(...) results in a no-op in SQLAlchemy unless the command is executed, use .filter(...).delete() instead.
  </Accordion>
</AccordionGroup>