How to use the SQL replace function in a Django ORM query

sql_replace_in_django_orm.py

from django.db.models import F, Func, Value
from myapp.models import MyModel

# Annotation
MyModel.objects.filter(description__icontains='\r\n').annotate(
    fixed_description=Func(
        F('description'),
        Value('\r\n'), Value('\n'),
        function='replace',
    )
)

# Bulk replace/fix
MyModel.objects.filter(description__icontains='\r\n').update(
    description=Func(
        F('description'),
        Value('\r\n'), Value('\n'),
        function='replace',
    )
)

Here's the SQL this generates (at least for MySQL):

UPDATE `myapp_mymodel`
    SET `description` = replace(`myapp_mymodel`.`description`, '\r\n', '\n')
    WHERE `myapp_mymodel`.`description` LIKE '%\r\n%'

This was quite helpful. Thanks!

Agreed, many thanks!

thank you, man, it's pretty cool!

thank you!

Why not just https://docs.djangoproject.com/en/3.1/ref/models/database-functions/#replace?