Query Language Snippets

Reset
All Snippets
Django ORM Read
Django ORM Q objects for complex queries.
from django.db.models import Q
users = User.objects.filter(Q(age__gt=25) | Q(department='HR'))
C# Entity Framework Read
Entity Framework include related entities.
var users = context.Users.Include(u => u.Profile).ToList();
foreach (var user in users)
{
    Console.WriteLine(user.Profile.Bio);
}
C# Entity Framework Read
Entity Framework raw SQL queries.
var users = context.Users.FromSqlRaw("SELECT * FROM Users WHERE Age > {0}", 25).ToList();
Kusto Read
Basic query to count records in a table.
StormEvents | count
Kusto Read
Filter and project fields.
StormEvents | where StartTime > datetime(2023-01-01) | project EventType, State
Kusto Read
Group by and aggregate data.
StormEvents | summarize count() by EventType
Kusto Read
Join two tables.
StormEvents | join kind=inner (States) on $left.State == $right.StateName | project EventType, State, StateName
Kusto Read
Use extend to add calculated columns.
StormEvents | extend Duration = EndTime - StartTime | project EventType, Duration
Kusto Read
Use summarize for aggregations.
StormEvents | summarize avg(DamageProperty), max(DamageCrops) by State
Kusto Read
Use where for filtering.
StormEvents | where EventType == "Flood" and State == "Texas"
SQLAlchemy Read
Use SQLAlchemy for aggregations.
from sqlalchemy import func
avg_age = session.query(func.avg(User.age)).scalar()
print(f'Average age: {avg_age}')
SQLModel Read
Query all records using SQLModel.
with Session(engine) as session:
    users = session.exec(select(User)).all()
    for user in users:
        print(user.name, user.age)