DryORM
Code
Result
no cache
Django 6.0
Django 5.2.8
Django 4.2.26 LTS
SQLAlchemy 2.0
Prisma 6.3
SQLite
PostgreSQL 17.4
PostGIS 3.5 (PostgreSQL 16)
MariaDB 11.4.5
Select a template
django
sqlalchemy
prisma
from django.db import models from django.db.models import Func, F, Value from django.db.models.functions import Coalesce class MD5(Func): function = 'md5' arity = 1 class User(models.Model): username = models.CharField(max_length=100, null=True) def run(): User.objects.bulk_create([ User(), User(), User(username='john') ]) qs = User.objects.annotate( hashed=MD5(Coalesce(F('username'), Value('POTATO'))) ) for row in qs: print(row.hashed)
Output
Show Template
No output.
Queries
INSERT
I
UPDATE
U
SELECT
S
DELETE
D
DDL
D
TCL
T
Queries
Q
(
0
)
No queries.
✖ Close
Save & Share
✖
private?
Save
Save & Copy